/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.XT_DM_YWBM DataRowToModel(DataRow row)
{
EDRS.Model.XT_DM_YWBM model = new EDRS.Model.XT_DM_YWBM();
if (row != null)
{
if (row["YWBM"] != null)
{
model.YWBM = row["YWBM"].ToString();
}
if (row["YWMC"] != null)
{
model.YWMC = row["YWMC"].ToString();
}
if (row["YWJC"] != null)
{
model.YWJC = row["YWJC"].ToString();
}
if (row["BZ"] != null)
{
model.BZ = row["BZ"].ToString();
}
if (row["SFSC"] != null && row["SFSC"].ToString() != "")
{
model.SFSC = row["SFSC"].ToString();
}
if (row["XH"] != null)
{
model.XH = int.Parse(row["XH"].ToString());
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.XT_DM_YWBM GetModel(string YWBM)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select YWBM,YWMC,YWJC,BZ,SFSC,XH from XT_DM_YWBM ");
strSql.Append(ConfigHelper.GetConfigString("OrcDBLinq"));
strSql.Append(" where YWBM=:YWBM ");
OracleParameter[] parameters =
{
new OracleParameter(":YWBM", OracleType.Char, 4)
};
parameters[0].Value = YWBM;
EDRS.Model.XT_DM_YWBM model = new EDRS.Model.XT_DM_YWBM();
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_YWBM GetModel(string YWBM)", "EDRS.OracleDAL.XT_DM_YWBM", 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 Add(EDRS.Model.XT_DM_YWBM model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into XT_DM_YWBM(");
strSql.Append("YWBM,YWMC,YWJC,BZ,SFSC,XH)");
strSql.Append(" values (");
strSql.Append(":YWBM,:YWMC,:YWJC,:BZ,:SFSC,:XH)");
OracleParameter[] parameters =
{
new OracleParameter(":YWBM", OracleType.VarChar, 2),
new OracleParameter(":YWMC", OracleType.VarChar, 60),
new OracleParameter(":YWJC", OracleType.VarChar, 60),
new OracleParameter(":BZ", OracleType.VarChar, 900),
new OracleParameter(":SFSC", OracleType.Char, 1),
new OracleParameter(":XH", OracleType.Number)
};
parameters[0].Value = model.YWBM;
parameters[1].Value = model.YWMC;
parameters[2].Value = model.YWJC;
parameters[3].Value = model.BZ;
parameters[4].Value = model.SFSC;
parameters[5].Value = model.XH;
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_DM_YWBM model)", "EDRS.OracleDAL.XT_DM_YWBM", 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 = "01";
XT_DM_YWBM bll = new XT_DM_YWBM(this.Request);
DataSet ds = bll.GetListByPage("", "ywbm desc", 1, 1, null);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
int num = int.Parse(ds.Tables[0].Rows[0]["YWBM"].ToString());
num++;
ywbm = num.ToString().PadLeft(2, '0');
}
EDRS.Model.XT_DM_YWBM model = new EDRS.Model.XT_DM_YWBM();
model.YWBM = ywbm;
model.YWMC = Request.Form["txt_name"];
model.YWJC = Request.Form["txt_namejc"];
model.BZ = Request.Form["txt_bz"];
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>
/// <returns></returns>
private string UpData()
{
string ywbm = Request.Form.Get("key_hidd").Trim();
if (string.IsNullOrEmpty(ywbm))
{
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
string msg = string.Empty;
if (!ProvingFrom(ref msg))
{
return(ReturnString.JsonToString(Prompt.error, msg, null));
}
XT_DM_YWBM bll = new XT_DM_YWBM(this.Request);
EDRS.Model.XT_DM_YWBM model = bll.GetModel(ywbm);
if (model != null)
{
model.YWMC = Request.Form["txt_name"];
model.YWJC = Request.Form["txt_namejc"];
model.BZ = Request.Form["txt_bz"];
if (bll.Update(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));
}
//数据日志
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 ywbm)
{
if (string.IsNullOrEmpty(ywbm))
{
ywbm = Request.Form.Get("id");
if (string.IsNullOrEmpty(ywbm))
{
return(ReturnString.JsonToString(Prompt.error, "参数错误", null));
}
}
XT_DM_YWBM bll = new XT_DM_YWBM(this.Request);
EDRS.Model.XT_DM_YWBM model = bll.GetModel(ywbm);
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));
}