/// <summary> /// 判断用户登录 /// </summary> /// <param name="sCode"></param> 编号 /// <param name="sUser"></param> 用户名 /// <param name="sPass"></param> 密码 /// <param name="dba"></param> 数据库操作 /// <returns></returns> 返回查询结果值 public int loginJudge(string sCode, string sUser, string sPass, dbAccess dba) { String sLog = "Select count(1) as usercount from users where user_code ='" + sCode + "' and user_detail = '" + sUser + "' and user_pwd = '" + sPass + "'"; return(Convert.ToInt32(getQueryResultBySQL(sLog))); }
private void Form1_Load(object sender, EventArgs e) { serverini = new IniFiles(@Application.StartupPath + "\\Config.ini"); FirstLocaltion = serverini.ReadValue("ResourceCodeParam", "FirstLocaltion"); Benindregion = serverini.ReadValue("ResourceCodeParam", "Benindregion"); dba = new dbAccess(); dba.conn.ConnectionString = GetConnectString(); dd = new List <OrganizationItem>(); }
/// <summary> /// 更新或新增记录 特殊用法 /// </summary> /// <param name="sTable"></param> 表名 /// <param name="sColValTye"></param> 字符串数组,组成方式为 “字段名,值,字段类型” /// <param name="sWhere"></param> 更新条件 /// <param name="dba"></param> 数据库处理对象 /// <returns></returns> 返回值,成功1、失败-1 public static int UpdateOrInsert(string sTable, int iMode, List <string> sColValTye, string sWhere, dbAccess dba) { try { string sSql = "", sSql2 = "", sTmp = ""; string[] strTmp; if (iMode == 1) //新增 { for (int i = 0; i < sColValTye.Count; i++) { if (sColValTye[i] == null || sColValTye[i].Length == 0) { continue; } strTmp = sColValTye[i].Split(','); if (strTmp.Length == 3) { if (strTmp[2].ToLower() == "string") { sSql += strTmp[0] + ","; sSql2 += "'" + strTmp[1] + "',"; } else if (strTmp[2].ToLower() == "datetime") { sSql += strTmp[0] + ","; sSql2 += "cast('" + strTmp[1] + "' as datetime),"; } else if (strTmp[2].ToLower() == "int") { sSql += strTmp[0] + ","; sSql2 += strTmp[1] + ","; } } else if (strTmp.Length > 3) { sTmp = ""; for (int j = 1; j < strTmp.Length - 1; j++) { sTmp = sTmp + strTmp[j] + ","; } sTmp = sTmp.TrimEnd(','); if (strTmp[strTmp.Length - 1].ToLower() == "string") { sSql += strTmp[0] + ","; sSql2 += "'" + sTmp + "',"; } else if (strTmp[strTmp.Length - 1].ToLower() == "datetime") { sSql += strTmp[0] + ","; sSql2 += "cast('" + strTmp[1] + "' as datetime),"; } else if (strTmp[strTmp.Length - 1].ToLower() == "int") { sSql += strTmp[0] + ","; sSql2 += sTmp + ","; } } } if (sSql.Length > 0) { sSql = sSql.TrimEnd(','); sSql2 = sSql2.TrimEnd(','); sSql = "Insert into " + sTable + "(" + sSql + ") values (" + sSql2 + ")"; } } else if (iMode == 2) //修改 { for (int i = 0; i < sColValTye.Count; i++) { if (sColValTye[i] == null || sColValTye[i].Length == 0) { continue; } strTmp = sColValTye[i].Split(','); if (strTmp.Length == 3) { if (strTmp[2].ToLower() == "string") { sSql += strTmp[0] + " = '" + strTmp[1] + "',"; } else if (strTmp[2].ToLower() == "datetime") { sSql += strTmp[0] + " = cast('" + strTmp[1] + "' as datetime),"; } else if (strTmp[2].ToLower() == "int") { sSql += strTmp[0] + " = " + strTmp[1] + ","; } } else if (strTmp.Length > 3) { sTmp = ""; for (int j = 1; j < strTmp.Length - 1; j++) { sTmp = sTmp + strTmp[j] + ","; } sTmp = sTmp.TrimEnd(','); if (strTmp[strTmp.Length - 1].ToLower() == "string") { sSql += strTmp[0] + " = '" + sTmp + "',"; } else if (strTmp[strTmp.Length - 1].ToLower() == "datetime") { sSql += strTmp[0] + " = cast('" + strTmp[1] + "' as datetime),"; } else if (strTmp[strTmp.Length - 1].ToLower() == "int") { sSql += strTmp[0] + " = " + sTmp + ","; } } } if (sSql.Length > 0) { sSql = sSql.TrimEnd(','); sSql = "Update " + sTable + " Set " + sSql + (sWhere.Length > 0 ? sWhere : ""); } } if (sSql.Length > 0 && dba.UpdateDbBySQL(sSql) != 1) { return(-1); } } catch { return(-1); } return(1); }