/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.XT_ZZJG_BMBM DataRowToModel(DataRow row)
{
EDRS.Model.XT_ZZJG_BMBM model = new EDRS.Model.XT_ZZJG_BMBM();
if (row != null)
{
if (row["BMBM"] != null)
{
model.BMBM = row["BMBM"].ToString();
}
if (row["DWBM"] != null)
{
model.DWBM = row["DWBM"].ToString();
}
if (row["FBMBM"] != null)
{
model.FBMBM = row["FBMBM"].ToString();
}
if (row["BMMC"] != null)
{
model.BMMC = row["BMMC"].ToString();
}
if (row["BMJC"] != null)
{
model.BMJC = row["BMJC"].ToString();
}
if (row["BMAHJC"] != null)
{
model.BMAHJC = row["BMAHJC"].ToString();
}
if (row["BMWHJC"] != null)
{
model.BMWHJC = row["BMWHJC"].ToString();
}
if (row["SFLSJG"] != null)
{
model.SFLSJG = row["SFLSJG"].ToString();
}
if (row["SFCBBM"] != null)
{
model.SFCBBM = row["SFCBBM"].ToString();
}
if (row["BMXH"] != null && row["BMXH"].ToString() != "")
{
model.BMXH = decimal.Parse(row["BMXH"].ToString());
}
if (row["BZ"] != null)
{
model.BZ = row["BZ"].ToString();
}
if (row["SFSC"] != null)
{
model.SFSC = row["SFSC"].ToString();
}
if (row["BMYS"] != null)
{
model.BMYS = row["BMYS"].ToString();
}
}
return(model);
}
/// <summary>
/// 添加部门数据
/// </summary>
/// <returns></returns>
private string AddDepartmentData()
{
string msg = string.Empty;
if (!ProvingFrom(ref msg))
{
return(ReturnString.JsonToString(Prompt.error, msg, null));
}
EDRS.Model.XT_ZZJG_BMBM model = new EDRS.Model.XT_ZZJG_BMBM();
model.DWBM = Request.Form.Get("hidd_superiorNumber");
model.BMBM = Request.Form.Get("txt_name");
model.FBMBM = Request.Form.Get("txt_abbreviation");
model.BMMC = Request.Form.Get("txt_number");
model.BMJC = Request.Form.Get("txt_rank");
model.BMAHJC = "";
model.BMWHJC = "";
model.SFLSJG = "";
model.SFCBBM = "";
model.BMXH = 0;
model.BMYS = "";
XT_ZZJG_BMBM bll = new XT_ZZJG_BMBM(this.Request);
if (bll.Add(model))
{
return(ReturnString.JsonToString(Prompt.win, "保存成功", null));
}
return(ReturnString.JsonToString(Prompt.error, "保存失败", null));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.XT_ZZJG_BMBM GetModel(string DWBM, string BMBM)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select BMBM,DWBM,FBMBM,BMMC,BMJC,BMAHJC,BMWHJC,SFLSJG,SFCBBM,BMXH,BZ,SFSC,BMYS from XT_ZZJG_BMBM ");
strSql.Append(ConfigHelper.GetConfigString("OrcDBLinq"));
strSql.Append(" where BMBM=:BMBM and DWBM=:DWBM ");
OracleParameter[] parameters =
{
new OracleParameter(":BMBM", OracleType.Char, 4),
new OracleParameter(":DWBM", OracleType.VarChar, 50)
};
parameters[0].Value = BMBM;
parameters[1].Value = DWBM;
EDRS.Model.XT_ZZJG_BMBM model = new EDRS.Model.XT_ZZJG_BMBM();
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_ZZJG_BMBM GetModel(string DWBM,string BMBM)", "EDRS.OracleDAL.XT_ZZJG_BMBM", strSql.ToString(), parameters);
}
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 根据编号获取数据
/// </summary>
/// <returns></returns>
private string GetModelOrParentList(string DWBM, string BMBM)
{
if (string.IsNullOrEmpty(BMBM))
{
BMBM = Request["id"];
if (string.IsNullOrEmpty(BMBM))
{
return(ReturnString.JsonToString(Prompt.error, "参数错误", null));
}
DWBM = Request["did"];
if (string.IsNullOrEmpty(DWBM))
{
return(ReturnString.JsonToString(Prompt.error, "参数错误", null));
}
}
XT_ZZJG_BMBM bll = new XT_ZZJG_BMBM(this.Request);
EDRS.Model.XT_ZZJG_BMBM model = bll.GetModel(DWBM, BMBM);
if (model != null)
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.部门管理Web, "根据部门编号获取部门成功", model.BMMC, UserInfo, UserRole, this.Request);
return(JsonHelper.JsonString(model));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.部门管理Web, "根据部门编号获取部门失败", Request["bmmc"], UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "获取数据失败", null));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(EDRS.Model.XT_ZZJG_BMBM model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into XT_ZZJG_BMBM(");
strSql.Append("BMBM,DWBM,FBMBM,BMMC,BMJC,BMAHJC,BMWHJC,SFLSJG,SFCBBM,BMXH,BZ,SFSC,BMYS)");
strSql.Append(" values (");
strSql.Append(":BMBM,:DWBM,:FBMBM,:BMMC,:BMJC,:BMAHJC,:BMWHJC,:SFLSJG,:SFCBBM,:BMXH,:BZ,:SFSC,:BMYS)");
OracleParameter[] parameters =
{
new OracleParameter(":BMBM", OracleType.Char, 4),
new OracleParameter(":DWBM", OracleType.VarChar, 50),
new OracleParameter(":FBMBM", OracleType.Char, 4),
new OracleParameter(":BMMC", OracleType.VarChar, 300),
new OracleParameter(":BMJC", OracleType.VarChar, 60),
new OracleParameter(":BMAHJC", OracleType.VarChar, 60),
new OracleParameter(":BMWHJC", OracleType.VarChar, 60),
new OracleParameter(":SFLSJG", OracleType.Char, 1),
new OracleParameter(":SFCBBM", OracleType.Char, 1),
new OracleParameter(":BMXH", OracleType.Number, 4),
new OracleParameter(":BZ", OracleType.VarChar, 900),
new OracleParameter(":SFSC", OracleType.Char, 1),
new OracleParameter(":BMYS", OracleType.Char, 1)
};
parameters[0].Value = model.BMBM;
parameters[1].Value = model.DWBM;
parameters[2].Value = model.FBMBM;
parameters[3].Value = model.BMMC;
parameters[4].Value = model.BMJC;
parameters[5].Value = model.BMAHJC;
parameters[6].Value = model.BMWHJC;
parameters[7].Value = model.SFLSJG;
parameters[8].Value = model.SFCBBM;
parameters[9].Value = model.BMXH;
parameters[10].Value = model.BZ;
parameters[11].Value = model.SFSC;
parameters[12].Value = model.BMYS;
int rows = 0;
try
{
rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
}
catch (Exception ex)
{
EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool Add(EDRS.Model.XT_ZZJG_BMBM model)", "EDRS.OracleDAL.XT_ZZJG_BMBM", strSql.ToString(), parameters);
}
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <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>
/// <param name="dwbm"></param>
/// <returns></returns>
private string UpData()
{
string id = Request.Form.Get("key_hidd");
string uid = Request.Form.Get("hidd_unitNumber").Trim();
if (string.IsNullOrEmpty(id) || !Regex.IsMatch(id, @"^[A-Za-z0-9]{1,8}$"))
{
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
if (string.IsNullOrEmpty(uid) || !Regex.IsMatch(id, @"^[A-Za-z0-9]{1,8}$"))
{
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
string msg = string.Empty;
//if (!ProvingFrom(ref msg))
// return ReturnString.JsonToString(Prompt.error, msg, null);
XT_ZZJG_BMBM bll = new XT_ZZJG_BMBM(this.Request);
EDRS.Model.XT_ZZJG_BMBM model = bll.GetModel(uid, id);
if (model != null)
{
model.BMMC = Request.Form.Get("txt_name").Trim();
model.BMJC = Request.Form.Get("txt_abbreviation").Trim();
//model.BMAHJC = Request.Form.Get("txt_abbreviationNum1").Trim();
//model.BMWHJC = Request.Form.Get("txt_abbreviationNum2").Trim();
//model.SFLSJG = Request.Form.Get("txt_temporary") == null ? "N" : "Y";
//model.SFCBBM = Request.Form.Get("txt_undertake") == null ? "0" : "1";
//model.BMXH = Convert.ToDecimal(Request.Form.Get("txt_number").Trim());
model.BZ = Request.Form.Get("txt_remark").Trim();
if (bll.Update(model))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.部门管理Web, "修改部门成功", model.BMMC, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "保存成功", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.部门管理Web, "修改部门失败", model.BMMC, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "保存失败", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.部门管理Web, "未找到修改部门信息", Request.Form.Get("txt_name"), UserInfo, UserRole, this.Request);
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 = "0001";
XT_ZZJG_BMBM bll = new XT_ZZJG_BMBM(this.Request);
EDRS.Model.XT_ZZJG_BMBM modelBM = bll.GetListOrderModel(" and rownum < 2", "BMBM desc", null);
if (modelBM != null)
{
number = (int.Parse(modelBM.BMBM.ToString()) + 1).ToString();
int len = 4 - number.Length;
for (int i = 0; i < len; i++)
{
number = number.Insert(0, "0");
}
}
EDRS.Model.XT_ZZJG_BMBM model = new EDRS.Model.XT_ZZJG_BMBM();
model.DWBM = Request.Form.Get("hidd_unitNumber").Trim();
model.BMBM = number;
model.FBMBM = Request.Form.Get("hidd_superiorNumber").Trim();
model.BMMC = Request.Form.Get("txt_name").Trim();
model.BMJC = Request.Form.Get("txt_abbreviation").Trim();
model.BMAHJC = "";
model.BMWHJC = "";
model.SFLSJG = "N";
model.SFCBBM = "0";
model.BMXH = 0;
model.BZ = Request.Form.Get("txt_remark").Trim();
model.BMYS = "";
if (bll.Add(model))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.部门管理Web, "添加部门成功", model.BMMC, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "保存成功", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.部门管理Web, "添加部门失败", model.BMMC, UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "保存失败", null));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(EDRS.Model.XT_ZZJG_BMBM model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update XT_ZZJG_BMBM set ");
strSql.Append("FBMBM=:FBMBM,");
strSql.Append("BMMC=:BMMC,");
strSql.Append("BMJC=:BMJC,");
strSql.Append("BMAHJC=:BMAHJC,");
strSql.Append("BMWHJC=:BMWHJC,");
strSql.Append("SFLSJG=:SFLSJG,");
strSql.Append("SFCBBM=:SFCBBM,");
strSql.Append("BMXH=:BMXH,");
strSql.Append("BZ=:BZ,");
strSql.Append("SFSC=:SFSC,");
strSql.Append("BMYS=:BMYS");
strSql.Append(" where BMBM=:BMBM and DWBM=:DWBM ");
OracleParameter[] parameters =
{
new OracleParameter(":DWBM", OracleType.VarChar, 50),
new OracleParameter(":FBMBM", OracleType.Char, 4),
new OracleParameter(":BMMC", OracleType.VarChar, 300),
new OracleParameter(":BMJC", OracleType.VarChar, 60),
new OracleParameter(":BMAHJC", OracleType.VarChar, 60),
new OracleParameter(":BMWHJC", OracleType.VarChar, 60),
new OracleParameter(":SFLSJG", OracleType.Char, 1),
new OracleParameter(":SFCBBM", OracleType.Char, 1),
new OracleParameter(":BMXH", OracleType.Number, 4),
new OracleParameter(":BZ", OracleType.VarChar, 900),
new OracleParameter(":SFSC", OracleType.Char, 1),
new OracleParameter(":BMYS", OracleType.Char, 1),
new OracleParameter(":BMBM", OracleType.Char, 4)
};
parameters[0].Value = model.DWBM;
parameters[1].Value = model.FBMBM;
parameters[2].Value = model.BMMC;
parameters[3].Value = model.BMJC;
parameters[4].Value = model.BMAHJC;
parameters[5].Value = model.BMWHJC;
parameters[6].Value = model.SFLSJG;
parameters[7].Value = model.SFCBBM;
parameters[8].Value = model.BMXH;
parameters[9].Value = model.BZ;
parameters[10].Value = model.SFSC;
parameters[11].Value = model.BMYS;
parameters[12].Value = model.BMBM;
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_ZZJG_BMBM model)", "EDRS.OracleDAL.XT_ZZJG_BMBM", strSql.ToString(), parameters);
}
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
