摘要：
string html = RenderControl(this.Page);//获取控件最终呈现的HTML,最好是Table MemoryStream stream = new MemoryStream(Encoding.UTF8.GetBytes(html)); System.IO.Memory 阅读全文
摘要：
/// <summary> /// 数据合并 /// </summary> /// <param name="mySheet"></param> /// <param name="columnIndex">合并的列下标</param> /// <param name="dataIndex">从哪一行 阅读全文
摘要：
Select * FROM ( Select sprid,RWID,spsj,spyj,sprmc from T_PROJ_DBRW_SPYJ Where sprid In('A','B','C','D') --And RWID in(56295,56186) ) pivot( Max(spsj) 阅读全文
摘要：
<MyCommand Name="日常测评列表" Database="ZDXMGL_SH" CommandType="Text"> <Parameters> <Parameter Name="Sysid" Type="Int32" Direction="Input" /> <Parameter Na 阅读全文
摘要：
<MyCommand Name="LoadDataSet" Database="DataBase" CommandType="Text"> <Parameters> <Parameter Name="cur1" Type="RefCursor" Direction="Output" /> <Para 阅读全文
摘要：
public class Program { static public Dictionary<string, Tuple<object, object>> GetChangedProperties<T>(T a, T b) where T : class { if ( a != null && b 阅读全文
摘要：
传参数的顺序一定要按照语句中 :参数 出现的顺序保持一致 阅读全文
摘要：
/// <summary> /// 注意，字段名必需大小写保持一致 /// </summary> protected static string updateSql = @" Merge into Table_Name T Using TempTable S ON (T.USER_ID = S.US 阅读全文
摘要：
private HttpClientHandler getHandler() { string cacheKey = "handlerChche"; HttpClientHandler handler = null; //cache.GetCache<HttpClientHandler>(cache 阅读全文
摘要：
public static string IPV4CIDR(string ipstart, string ipend) { var sl = ipstart.Split('.'); var el = ipend.Split("."); StringBuilder sbs = new StringBu 阅读全文