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