摘要:
List paras = new List(); string wherSql = PreWhereSQL + GetQuerySql(paras);string GetQuerySql(List paras) { StringBuilder where = new StringBuilder(" and 1=1"); if (!string.IsNullOrEmpty(tbWorkOrderNo.Text.Trim())) { where.Append(" and SgWorkOrderNo like @p_... 阅读全文
摘要:
tb_Project表:IDProjectCreaterProjectPrincipal...112...tb_User表:IDUserRealName1张三2李四select a.*,b.UserRealName as Creater,c.UserRealName as Principal from tb_Project a, tb_User b, tb_User c where a.ProjectCreater=b.ID and a.ProjectPrincipal=c.ID结果:tb_Project表:IDProjectCreaterProjectPrincipal...CreaterP 阅读全文
摘要:
/// /// 获取汉字首字母(可包含多个汉字) /// /// /// public string GetChineseSpell(string strText) { int len = strText.Length; string myStr = ""; for (int i = 0; i 1) { int area = (short)arrCN[0]; int pos = (short)arrCN[1]; int code = (... 阅读全文