/// <summary> /// 修改 /// </summary> /// <param name="dwbm"></param> /// <returns></returns> private string UpData() { string JSBM = Request.Form.Get("key_hidd"); string BMBM = Request.Form.Get("key_hidd_dw"); string DWBM = Request.Form.Get("hidd_unitNumber"); if (string.IsNullOrEmpty(JSBM) || string.IsNullOrEmpty(BMBM) || string.IsNullOrEmpty(DWBM)) { return(ReturnString.JsonToString(Prompt.error, "参数错误", null)); } string msg = string.Empty; //if (!ProvingFrom(ref msg)) // return ReturnString.JsonToString(Prompt.error, msg, null); XT_QX_JSBM bll = new XT_QX_JSBM(this.Request); EDRS.Model.XT_QX_JSBM model = bll.GetModel(JSBM, BMBM, DWBM); if (model != null) { model.JSMC = Request.Form.Get("txt_name").Trim(); model.JSXH = Convert.ToDecimal(Request.Form.Get("txt_number").Trim()); if (bll.Update(model)) { return(ReturnString.JsonToString(Prompt.win, "保存成功", null)); } return(ReturnString.JsonToString(Prompt.error, "保存失败", null)); } else { return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null)); } }
/// <summary> /// 添加角色数据 /// </summary> /// <returns></returns> private string AddData() { string msg = string.Empty; if (!ProvingFrom(ref msg)) { return(ReturnString.JsonToString(Prompt.error, msg, null)); } string number = "001"; XT_ZZJG_BMBM bllBM = new XT_ZZJG_BMBM(this.Request); EDRS.Model.XT_ZZJG_BMBM modelBM = bllBM.GetModel("", Request.Form.Get("hidd_unitNumber").Trim()); if (modelBM == null) { return(ReturnString.JsonToString(Prompt.error, "选择部门不是有效部门,请重新选择", null)); } XT_QX_JSBM bll = new XT_QX_JSBM(this.Request); //获取角色数据编号中最大的一个编号 EDRS.Model.XT_QX_JSBM modelJS = bll.GetListOrderModel(" and DWBM='" + modelBM.DWBM + "' and BMBM='" + modelBM.BMBM + "' and rownum < 2", "JSBM desc", null); if (modelJS != null) { //将数据中最大编号加1表示自增防止编号重复 number = (int.Parse(modelJS.JSBM.ToString()) + 1).ToString(); int len = 3 - number.Length; //字符长度未到3在数字前面自动加0 for (int i = 0; i < len; i++) { number = number.Insert(0, "0"); } } EDRS.Model.XT_QX_JSBM model = new EDRS.Model.XT_QX_JSBM(); model.DWBM = modelBM.DWBM; model.BMBM = modelBM.BMBM; model.JSBM = number; model.JSMC = Request.Form.Get("txt_name").Trim(); model.JSXH = Convert.ToDecimal(Request.Form.Get("txt_number").Trim()); model.SPJSBM = ""; if (bll.Add(model)) { return(ReturnString.JsonToString(Prompt.win, "保存成功", null)); } return(ReturnString.JsonToString(Prompt.error, "保存失败", null)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(EDRS.Model.XT_QX_JSBM model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update XT_QX_JSBM set "); strSql.Append("JSMC=:JSMC,"); strSql.Append("JSXH=:JSXH,"); strSql.Append("SPJSBM=:SPJSBM"); strSql.Append(" where JSBM=:JSBM and DWBM=:DWBM and BMBM=:BMBM"); OracleParameter[] parameters = { new OracleParameter(":DWBM", OracleType.VarChar, 50), new OracleParameter(":BMBM", OracleType.Char, 4), new OracleParameter(":JSBM", OracleType.Char, 3), new OracleParameter(":JSMC", OracleType.VarChar, 60), new OracleParameter(":JSXH", OracleType.Number, 4), new OracleParameter(":SPJSBM", OracleType.Char, 2) }; parameters[0].Value = model.DWBM; parameters[1].Value = model.BMBM; parameters[2].Value = model.JSBM; parameters[3].Value = model.JSMC; parameters[4].Value = model.JSXH; parameters[5].Value = model.SPJSBM; int rows = 0; try { rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); } catch (Exception ex) { EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, " public bool Update(EDRS.Model.XT_QX_JSBM model)", "EDRS.OracleDAL.XT_QX_JSBM", strSql.ToString(), parameters); } if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 根据编号获取数据 /// </summary> /// <returns></returns> private string GetModelOrParentList() { string JSBM = Request["id"]; string BMBM = Request["bmid"]; string DWBM = Request["dwid"]; if (string.IsNullOrEmpty(JSBM) || string.IsNullOrEmpty(BMBM) || string.IsNullOrEmpty(DWBM)) { return(ReturnString.JsonToString(Prompt.error, "参数错误", null)); } XT_QX_JSBM bll = new XT_QX_JSBM(this.Request); EDRS.Model.XT_QX_JSBM model = bll.GetModel(JSBM, DWBM, BMBM); if (model != null) { return(JsonHelper.JsonString(model)); } return(ReturnString.JsonToString(Prompt.error, "获取数据失败", null)); }
/// <summary> /// 得到一个对象实体 /// </summary> public EDRS.Model.XT_QX_JSBM DataRowToModel(DataRow row) { EDRS.Model.XT_QX_JSBM model = new EDRS.Model.XT_QX_JSBM(); if (row != null) { if (row["JSBM"] != null) { model.JSBM = row["JSBM"].ToString(); } if (row["DWBM"] != null) { model.DWBM = row["DWBM"].ToString(); } if (row["BMBM"] != null) { model.BMBM = row["BMBM"].ToString(); } if (row["BMMC"] != null) { model.BMMC = row["BMMC"].ToString(); } if (row["JSMC"] != null) { model.JSMC = row["JSMC"].ToString(); } if (row["JSXH"] != null && row["JSXH"].ToString() != "") { model.JSXH = decimal.Parse(row["JSXH"].ToString()); } if (row["SPJSBM"] != null) { model.SPJSBM = row["SPJSBM"].ToString(); } if (row["QXZT"] != null) { model.QXZT = row["QXZT"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public EDRS.Model.XT_QX_JSBM GetModel(string JSBM, string DWBM, string BMBM) { StringBuilder strSql = new StringBuilder(); strSql.Append("select JSBM,DWBM,BMBM,JSMC,JSXH,SPJSBM from XT_QX_JSBM "); strSql.Append(ConfigHelper.GetConfigString("OrcDBLinq")); strSql.Append(" where JSBM=:JSBM and DWBM=:DWBM and BMBM=:BMBM "); OracleParameter[] parameters = { new OracleParameter(":JSBM", OracleType.Char, 3), new OracleParameter(":DWBM", OracleType.VarChar, 50), new OracleParameter(":BMBM", OracleType.Char, 4) }; parameters[0].Value = JSBM; parameters[1].Value = DWBM; parameters[2].Value = BMBM; EDRS.Model.XT_QX_JSBM model = new EDRS.Model.XT_QX_JSBM(); DataSet ds = null; try { ds = DbHelperOra.Query(strSql.ToString(), parameters); } catch (Exception ex) { EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public EDRS.Model.XT_QX_JSBM GetModel(string JSBM, string DWBM, string BMBM)", "EDRS.OracleDAL.XT_QX_JSBM", strSql.ToString(), parameters); } if (ds != null && ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }