/// <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");
}
