/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.XT_DM_AJLBBM DataRowToModel(DataRow row)
{
EDRS.Model.XT_DM_AJLBBM model = new EDRS.Model.XT_DM_AJLBBM();
if (row != null)
{
if (row["YWBM"] != null)
{
model.YWBM = row["YWBM"].ToString();
}
if (row["AJLBBM"] != null)
{
model.AJLBBM = row["AJLBBM"].ToString();
}
if (row["AJLBMC"] != null)
{
model.AJLBMC = row["AJLBMC"].ToString();
}
if (row["AJSLJC"] != null)
{
model.AJSLJC = row["AJSLJC"].ToString();
}
if (row["SFSC"] != null && row["SFSC"].ToString() != "")
{
model.SFSC = row["SFSC"].ToString();
}
if (row["XH"] != null && row["XH"].ToString() != "")
{
model.XH = int.Parse(row["XH"].ToString());
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.XT_DM_AJLBBM GetModel(string AJLBBM)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select YWBM,AJLBBM,AJLBMC,AJSLJC,SFSC,XH from XT_DM_AJLBBM ");
strSql.Append(ConfigHelper.GetConfigString("OrcDBLinq"));
strSql.Append(" where AJLBBM=:AJLBBM ");
OracleParameter[] parameters =
{
new OracleParameter(":AJLBBM", OracleType.VarChar, 50)
};
parameters[0].Value = AJLBBM;
EDRS.Model.XT_DM_AJLBBM model = new EDRS.Model.XT_DM_AJLBBM();
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_DM_AJLBBM GetModel(string AJLBBM)", "EDRS.OracleDAL.XT_DM_AJLBBM", strSql.ToString(), parameters);
}
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(EDRS.Model.XT_DM_AJLBBM model, string ajlbbm)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update XT_DM_AJLBBM set ");
strSql.Append(" YWBM=:YWBM,AJLBBM=:AJLBBM,AJLBMC=:AJLBMC,AJSLJC=:AJSLJC,SFSC=:SFSC,XH=:XH ");
strSql.Append(" where AJLBBM=:AJLBBM2 ");
OracleParameter[] parameters =
{
new OracleParameter(":YWBM", OracleType.Char, 2),
new OracleParameter(":AJLBBM", OracleType.VarChar, 50),
new OracleParameter(":AJLBMC", OracleType.VarChar, 300),
new OracleParameter(":AJSLJC", OracleType.VarChar, 60),
new OracleParameter(":SFSC", OracleType.Char, 1),
new OracleParameter(":XH", OracleType.Number),
new OracleParameter(":AJLBBM2", OracleType.VarChar, 50)
};
parameters[0].Value = model.YWBM;
parameters[1].Value = model.AJLBBM;
parameters[2].Value = model.AJLBMC;
parameters[3].Value = model.AJSLJC;
parameters[4].Value = model.SFSC;
parameters[5].Value = model.XH;
parameters[6].Value = ajlbbm;
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_DM_AJLBBM model)", "EDRS.OracleDAL.XT_DM_AJLBBM", 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 ywbm = Request.Form.Get("slct_type_val");
string ajlbbm = ywbm + "01";
XT_DM_AJLBBM bll = new XT_DM_AJLBBM(this.Request);
DataSet ds = bll.GetListByPage(" and ywbm=:ywbm ", "ajlbbm desc", 1, 1, new object[] { ywbm });
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
string lb = ds.Tables[0].Rows[0]["AJLBBM"].ToString();
lb = lb.Substring(ywbm.Length, lb.Length - ywbm.Length);
int num = int.Parse(lb);
num++;
ajlbbm = ywbm + num.ToString().PadLeft(lb.Length, '0');
}
EDRS.Model.XT_DM_AJLBBM model = new EDRS.Model.XT_DM_AJLBBM();
model.YWBM = ywbm;
model.AJLBBM = ajlbbm;
model.AJLBMC = Request.Form.Get("txt_lbname");
model.AJSLJC = Request.Form.Get("txt_sljc");
model.SFSC = "N";
if (bll.Add(model))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.参数配置Web, "添加类别成功", "", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "保存成功", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.参数配置Web, "添加类别失败", "", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "保存失败", null));
}
/// <summary>
/// 根据类别编号获取数据
/// </summary>
/// <param name="DWBM"></param>
/// <returns></returns>
private string GetModel(string ajlbbm)
{
if (string.IsNullOrEmpty(ajlbbm))
{
ajlbbm = Request.Form.Get("id");
if (string.IsNullOrEmpty(ajlbbm))
{
return(ReturnString.JsonToString(Prompt.error, "参数错误", null));
}
}
XT_DM_AJLBBM bll = new XT_DM_AJLBBM(this.Request);
EDRS.Model.XT_DM_AJLBBM model = bll.GetModel(ajlbbm);
if (model != null)
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.参数配置Web, "根据编号获取类型信息成功", "", UserInfo, UserRole, this.Request);
return(JsonHelper.JsonString(model));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.参数配置Web, "根据编号获取类型信息失败", "", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "获取数据失败", null));
}
/// <summary>
/// 修改类别
/// </summary>
/// <returns></returns>
private string UpData()
{
string ajlbbm = Request.Form.Get("key_hidd").Trim();
if (string.IsNullOrEmpty(ajlbbm))
{
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
string msg = string.Empty;
if (!ProvingFrom(ref msg))
{
return(ReturnString.JsonToString(Prompt.error, msg, null));
}
XT_DM_AJLBBM bll = new XT_DM_AJLBBM(this.Request);
EDRS.Model.XT_DM_AJLBBM model = bll.GetModel(ajlbbm);
if (model != null)
{
string ywbm = Request.Form.Get("slct_type_val");
string ajlbbmNew = ywbm + "01";
//业务类型不同重新设置编号
if (model.YWBM != ywbm)
{
DataSet ds = bll.GetListByPage(" and ywbm=:ywbm ", "ajlbbm desc", 1, 1, new object[] { ywbm });
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
//int num = int.Parse(ds.Tables[0].Rows[0]["AJLBBM"].ToString().Substring(2, 2));
//num++;
//ajlbbmNew = Request.Form.Get("slct_type_val") + num.ToString().PadLeft(2, '0');
string lb = ds.Tables[0].Rows[0]["AJLBBM"].ToString();
lb = lb.Substring(ywbm.Length, lb.Length - ywbm.Length);
int num = int.Parse(lb);
num++;
ajlbbmNew = ywbm + num.ToString().PadLeft(lb.Length, '0');
}
model.AJLBBM = ajlbbmNew;
}
model.YWBM = Request.Form.Get("slct_type_val");
model.AJLBMC = Request.Form.Get("txt_lbname");
model.AJSLJC = Request.Form.Get("txt_sljc");
if (bll.Update(model, ajlbbm))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.参数配置Web, "修改类别成功", "", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "保存成功", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.参数配置Web, "修改类别失败", "", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "保存失败", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.参数配置Web, "修改类别未找到信息", "", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
