public int UpdateConfig(WEB_CUSTOMSCOST en) { string sqlStr = @"update WEB_CUSTOMSCOST set Busitypecode='{0}',Busitypename='{1}',Busiitemcode='{2}',Busiitemname='{3}',Originname='{4}',Configname='{5}',Createuserid='{6}',Createusername='******' where id='{8}'"; sqlStr = string.Format(sqlStr, en.BUSITYPECODE, en.BUSITYPENAME, en.BUSIITEMCODE, en.BUSIITEMNAME, en.ORIGINNAME, en.CONFIGNAME, en.CREATEUSERID, en.CREATEUSERNAME, en.ID); int i = DBMgr.ExecuteNonQuery(sqlStr); return(i); }
/// <summary> /// 新增一笔记录 /// </summary> /// <param name="en"></param> /// <returns></returns> public int AddConfig(WEB_CUSTOMSCOST en) { string sqlStr = @"insert into WEB_CUSTOMSCOST (Id,Busitypecode,Busitypename,Busiitemcode,Busiitemname,Originname,Configname,Createuserid,Createusername) values(web_customsconfig_id.nextval,'{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')"; sqlStr = string.Format(sqlStr, en.BUSITYPECODE, en.BUSITYPENAME, en.BUSIITEMCODE, en.BUSIITEMNAME, en.ORIGINNAME, en.CONFIGNAME, en.CREATEUSERID, en.CREATEUSERNAME); int i = DBMgr.ExecuteNonQuery(sqlStr); return(i); }
public string CanUpdateOrInsert(WEB_CUSTOMSCOST en) { string repeat = ""; string strWhere = ""; if (en.ID > 0) { strWhere = " and t1.id not in ('" + en.ID + "') "; } string sqlStr = "select * from WEB_CUSTOMSCOST t1 where t1.BUSITYPECODE='{0}' and t1.BUSIITEMCODE='{1}' and t1.ORIGINNAME='{2}' " + strWhere; sqlStr = string.Format(sqlStr, en.BUSITYPECODE, en.BUSIITEMCODE, en.ORIGINNAME); DataTable dt = DBMgr.GetDataTable(sqlStr); if (dt != null && dt.Rows.Count > 0) { repeat += "不能重复"; } return(repeat); }
/// <summary> /// 保存或更新数据 /// </summary> /// <param name="formdata"></param> public void save(string formdata) { string response = ""; string repeat = ""; JObject json = (JObject)JsonConvert.DeserializeObject(formdata); WEB_CUSTOMSCOST en = JsonToEntity(json); if (en == null) { repeat = "保存失败,JSON数据转换出现问题"; } else if (en.ID < 0) { //新增 repeat = CanUpdateOrInsert(en); if (string.IsNullOrEmpty(repeat)) { int i = AddConfig(en); if (i > 0) { repeat = "5";//代表成功 } } } else { //更新 repeat = CanUpdateOrInsert(en); if (string.IsNullOrEmpty(repeat)) { int i = UpdateConfig(en); if (i > 0) { repeat = "5";//代表成功 } } } response = "{\"success\":\"" + repeat + "\"}"; Response.Write(response); Response.End(); }
public WEB_CUSTOMSCOST JsonToEntity(JObject json) { WEB_CUSTOMSCOST en = new WEB_CUSTOMSCOST(); try { if (!string.IsNullOrEmpty(json.Value <string>("ID"))) { en.ID = Convert.ToInt32(json.Value <string>("ID")); } else { en.ID = -1; } en.BUSITYPECODE = json.Value <string>("BUSITYPECODE"); string sqlStr = "select * from web_customsconfig t1 where t1.busitypecode='" + en.BUSITYPECODE + "'"; DataTable dt = DBMgr.GetDataTable(sqlStr); en.BUSITYPENAME = dt.Rows[0]["busitypename"].ToString(); en.BUSIITEMCODE = json.Value <string>("BUSIITEMCODE"); sqlStr = "select * from web_customsconfig t1 where t1.busiitemcode='" + en.BUSIITEMCODE + "'"; dt = DBMgr.GetDataTable(sqlStr); en.BUSIITEMNAME = dt.Rows[0]["busiitemname"].ToString(); en.CONFIGNAME = json.Value <string>("CONFIGNAME"); en.ORIGINNAME = json.Value <string>("ORIGINNAME"); FormsIdentity identity = HttpContext.Current.User.Identity as FormsIdentity; string userName = identity.Name; JObject json_user = Extension.Get_UserInfo(userName); en.CREATEUSERID = (Int32)json_user.GetValue("ID"); en.CREATEUSERNAME = (string)json_user.GetValue("REALNAME"); en.REASON = json.Value <string>("REASON"); return(en); } catch { return(null); } }