/// <summary> /// 修改用户信息 /// </summary> /// <param name="info"></param> /// <returns></returns> public static bool Update(CFG_USERINFO info) { bool isSuccess = true; StringBuilder pUpdateText = new StringBuilder(); pUpdateText.Append("UPDATE CFG_USERINFO SET NAME='" + info.NAME + "',SEX=" + info.SEX + ",AGE='" + info.AGE + "',TELEPHONE='" + info.TELEPHONE + "',CERTIFICATETYPE=" + info.CERTIFICATETYPE + ","); pUpdateText.Append("CERTIFICATENUM='" + info.CERTIFICATENUM + "',DIRECTION='" + info.DIRECTION + "',BELONGDEPTID=" + info.BELONGDEPTID + ",BELONGNETID=" + info.BELONGNETID + ",ADDRESS='" + info.ADDRESS + "', "); pUpdateText.Append("REMARK='" + info.REMARK + "',USERTYPE=" + info.USERTYPE + ",VIRTUALTRUMPET='" + info.VIRTUALTRUMPET + "',USERNAME='******',USERPWD='" + info.USERPWD + "',LOGINTYPE= " + info.LOGINTYPE + " "); pUpdateText.Append("WHERE ID=" + info.ID); try { OracleOperateBLL.ExecuteSql(pUpdateText.ToString()); } catch { isSuccess = false; } return(isSuccess); //DbBase<CFG_USERINFO> db = new DbBase<CFG_USERINFO>(); //db.Update(info); //if (db.SaveChanges() >= 0) //{ // return true; //} //else //{ // return false; //} }
/// <summary> /// 添加用户信息 /// </summary> /// <param name="info"></param> /// <returns></returns> public static bool Add(CFG_USERINFO info) { bool isSuccess = true; StringBuilder pInsertText = new StringBuilder(); pInsertText.Append("INSERT INTO CFG_USERINFO(NAME,SEX,AGE,TELEPHONE,CERTIFICATETYPE,CERTIFICATENUM,DIRECTION,BELONGDEPTID,BELONGNETID,ADDRESS,REMARK,ISDELETED,USERTYPE,VIRTUALTRUMPET,USERNAME,USERPWD,LOGINTYPE) VALUES('"); pInsertText.Append(info.NAME + "'," + info.SEX + ",'" + info.AGE + "','" + info.TELEPHONE + "'," + info.CERTIFICATETYPE + ",'" + info.CERTIFICATENUM + "','" + info.DIRECTION + "',"); pInsertText.Append(info.BELONGDEPTID + "," + info.BELONGNETID + ",'" + info.ADDRESS + "','" + info.REMARK + "'," + info.ISDELETED + "," + info.USERTYPE + ",'"); pInsertText.Append(info.VIRTUALTRUMPET + "','" + info.USERNAME + "','" + info.USERPWD + "'," + info.LOGINTYPE + ")"); try { OracleOperateBLL.ExecuteSql(pInsertText.ToString()); } catch { isSuccess = false; } return(isSuccess); //DbBase<CFG_USERINFO> db = new DbBase<CFG_USERINFO>(); //db.Insert(info); //if (db.SaveChanges() >= 0) //{ // return true; //} //else //{ // return false; //} }
public ActionResult btnSave_Click(FormCollection values) { CFG_USERINFO info = new CFG_USERINFO(); info.ID = Convert.ToInt32(values["Id"]); info.NAME = values["Name"]; info.SEX = Convert.ToInt32(values["Sex"]); info.USERNAME = values["UserName"]; info.USERPWD = values["UserPwd"]; info.AGE = values["Age"]; info.TELEPHONE = values["Telephone"]; info.CERTIFICATETYPE = Convert.ToInt32(values["CertificateType"]); info.CERTIFICATENUM = values["CertificateNum"]; info.DIRECTION = values["Direction"]; info.ADDRESS = values["Address"]; info.BELONGDEPTID = Convert.ToInt32(values["BelongDeptId"]); info.BELONGNETID = string.IsNullOrWhiteSpace(values["BelongNetId"]) ? -1 : Convert.ToInt32(values["BelongNetId"]); info.USERTYPE = Convert.ToInt32(values["UserType"]); info.REMARK = values["Remark"]; info.LOGINTYPE = Convert.ToInt32(values["LoginType"]); info.VIRTUALTRUMPET = values["VirtualTrumpet"]; var isSuccess = UserBLL.Update(info); ActiveWindow.HidePostBack(); if (isSuccess) { ShowNotify("数据修改成功!"); } else { ShowNotify("数据修改失败!"); } return(UIHelper.Result()); }
public static CFG_USERINFO Get(string phone) { CFG_USERINFO pUserInfo = new CFG_USERINFO(); OracleConnection pConn = null; OracleCommand pComm = null; OracleDataReader pReader = null; pConn = new OracleConnection(ORACLE_CONNECTION_STRING); pConn.Open(); string pCmdText = "SELECT ID,NAME,SEX,AGE,TELEPHONE,CERTIFICATETYPE,CERTIFICATENUM,DIRECTION,BELONGDEPTID,BELONGNETID,ADDRESS,REMARK,ISDELETED,USERTYPE,VIRTUALTRUMPET,USERNAME,USERPWD,LOGINTYPE FROM CFG_USERINFO WHERE TELEPHONE = '" + phone + "'"; pComm = new OracleCommand(pCmdText, pConn); pReader = pComm.ExecuteReader(); while (pReader.Read()) { pUserInfo.ID = Convert.ToInt32(pReader["ID"]); pUserInfo.NAME = Convert.ToString(pReader["NAME"]); pUserInfo.SEX = Convert.ToInt32(pReader["SEX"]); pUserInfo.AGE = Convert.ToString(pReader["AGE"]); pUserInfo.TELEPHONE = Convert.ToString(pReader["TELEPHONE"]); pUserInfo.CERTIFICATETYPE = Convert.ToInt32(pReader["CERTIFICATETYPE"]); pUserInfo.CERTIFICATENUM = Convert.ToString(pReader["CERTIFICATENUM"]); pUserInfo.DIRECTION = Convert.ToString(pReader["DIRECTION"]); pUserInfo.BELONGDEPTID = Convert.ToInt32(pReader["BELONGDEPTID"]); pUserInfo.BELONGNETID = Convert.ToInt32(pReader["BELONGNETID"]); pUserInfo.ADDRESS = Convert.ToString(pReader["ADDRESS"]); pUserInfo.REMARK = Convert.ToString(pReader["REMARK"]); pUserInfo.ISDELETED = Convert.ToInt32(pReader["ISDELETED"]); pUserInfo.USERTYPE = Convert.ToInt32(pReader["USERTYPE"]); pUserInfo.VIRTUALTRUMPET = Convert.ToString(pReader["VIRTUALTRUMPET"]); pUserInfo.USERNAME = Convert.ToString(pReader["USERNAME"]); pUserInfo.USERPWD = Convert.ToString(pReader["USERPWD"]); pUserInfo.LOGINTYPE = Convert.ToInt32(pReader["LOGINTYPE"]); } if (pReader != null) { pReader.Close(); pReader.Dispose(); } if (pComm != null) { pComm.Dispose(); } if (pConn != null) { pConn.Close(); pConn.Dispose(); } return(pUserInfo); //DbBase<CFG_USERINFO> db = new DbBase<CFG_USERINFO>(); //return db.FirstOrDefault(p => p.TELEPHONE == phone); }
/// <summary> /// 获取所有人员 /// </summary> /// <returns></returns> public static List <CFG_USERINFO> GetAll() { StringBuilder pSBQueryText = new StringBuilder(); pSBQueryText.Append("SELECT ID,NAME,SEX,AGE,TELEPHONE,CERTIFICATETYPE,CERTIFICATENUM,DIRECTION,BELONGDEPTID,BELONGNETID,ADDRESS,REMARK,ISDELETED,USERTYPE,VIRTUALTRUMPET,USERNAME,USERPWD,LOGINTYPE FROM CFG_USERINFO WHERE ISDELETED=0"); var data = OracleOperateBLL.FillDataTable(pSBQueryText.ToString()); List <CFG_USERINFO> userInfoList = new List <CFG_USERINFO>(); foreach (DataRow dr in data.Rows) { CFG_USERINFO d = new CFG_USERINFO(); d.ID = Convert.ToInt32(dr["ID"]); d.NAME = Convert.ToString(dr["NAME"]); d.SEX = Convert.ToInt32(dr["SEX"]); d.AGE = Convert.ToString(dr["AGE"]); d.TELEPHONE = Convert.ToString(dr["TELEPHONE"]); d.CERTIFICATETYPE = Convert.ToInt32(dr["CERTIFICATETYPE"]); d.CERTIFICATENUM = Convert.ToString(dr["CERTIFICATENUM"]); d.DIRECTION = Convert.ToString(dr["DIRECTION"]); d.BELONGDEPTID = Convert.ToInt32(dr["BELONGDEPTID"]); d.BELONGNETID = Convert.ToInt32(dr["BELONGNETID"]); d.ADDRESS = Convert.ToString(dr["ADDRESS"]); d.REMARK = Convert.ToString(dr["REMARK"]); d.ISDELETED = Convert.ToInt32(dr["ISDELETED"]); d.USERTYPE = Convert.ToInt32(dr["USERTYPE"]); d.VIRTUALTRUMPET = Convert.ToString(dr["VIRTUALTRUMPET"]); d.USERNAME = Convert.ToString(dr["USERNAME"]); d.USERPWD = Convert.ToString(dr["USERPWD"]); d.LOGINTYPE = Convert.ToInt32(dr["LOGINTYPE"]); userInfoList.Add(d); } return(userInfoList); //DbBase<CFG_USERINFO> db = new DbBase<CFG_USERINFO>(); //return db.GetAll(p => p.ISDELETED == 0, "NAME"); }