1. VS快捷键 shift + alt 可以选中某一列,可以对某一列批量操作
2. 开线程 一般程序处理太多事情,会出现假死状态,此时要开多线程完成其他需要完成的task
Thread _thread = new Thread(t => calc()) { IsBackground = false,Priority = ThreadPriority.BelowNormal};
_thread.Start();
3. 前台form提交表单,当字段中含有html代码时,后台的string类型变量接收不到,表单提交后台失败。对于这种问题,采用encodeURIComponent封装加密,在后台使用Server.UrlDecode解密即可完成前后台交互;
4.前台文本框中含有HTML代码,submit提交后,c#后台string类型的字段映射接不到内容且报错,需要在方法上打上标签特性[ValidateInput(false)],就可以接收到啦
5.支付宝接口文档和demo https://doc.open.alipay.com/docs/doc.htm?treeId=62&articleId=104746&docType=1 微信接口和demo https://pay.weixin.qq.com/wiki/doc/api/native.php?chapter=6_4
6.NPOI 导入Excel
string road = System.AppDomain.CurrentDomain.BaseDirectory + "IndexCode.xls";
using (FileStream file = new FileStream(road, FileMode.Open, FileAccess.Read))
{
hssfworkbook = new HSSFWorkbook(file);
}
NPOI.SS.UserModel.ISheet importSheet = hssfworkbook.GetSheetAt(0);
System.Collections.IEnumerator importRows = importSheet.GetRowEnumerator();
int i = 0;
while (importRows.MoveNext())
{
if (i > 0)
{
HSSFRow importRow = (HSSFRow)importRows.Current;
string indexCode = importRow.GetCell(0) == null ? string.Empty : importRow.GetCell(0).ToString();
if (string.IsNullOrEmpty(indexCode))
{
break;
}
try
{
DataIndex idx = DataCenterService.GetDataIndexById(indexCode);
tmpDataIndex.Add(idx);
}
catch (Exception ex)
{
LogM.WriteError("导入指标第" + i.ToString() + "行查询信息报错:" + ex.Message.ToString());
}
}
i++;
}
ExportIndexHelper(tmpDataIndex, ref sheet, ref Export_num, book);
7. css样式控制td自动换行展示数据
white-space:normal; overflow: hidden; TEXT-OVERFLOW:ellipsis; word-break:break-all; word-wrap:break-word;
8.select选择框的操作 var selectIndex = $("#DataBase").prop('selectedIndex'),
categoryid = $("#DataBase").find('option').eq(selectIndex).attr("value");
var obj = document.getElementById("webSiteId"); //定位id
var index = obj.selectedIndex; // 选中索引
var text = obj.options[index].text; // 选中文本
var value = obj.options[index].value; // 选中值
9. var chart = echarts.init(document.getElementById("chart1"));
chart.setOption(option);
window.addEventListener('resize', function () {
chart.resize();
});
10.自动换行,IE下右侧空格处理 text-align: justify; text-justify: inter-ideograph;