/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.XT_DZJZ_SSLB DataRowToModel(DataRow row)
{
EDRS.Model.XT_DZJZ_SSLB model = new EDRS.Model.XT_DZJZ_SSLB();
if (row != null)
{
if (row["SSLBBM"] != null)
{
model.SSLBBM = row["SSLBBM"].ToString();
}
if (row["FSSLBBM"] != null)
{
model.FSSLBBM = row["FSSLBBM"].ToString();
}
if (row["SSLBLX"] != null)
{
model.SSLBLX = row["SSLBLX"].ToString();
}
if (row["SSLBMC"] != null)
{
model.SSLBMC = row["SSLBMC"].ToString();
}
if (row["SSLBSX"] != null && row["SSLBSX"].ToString() != "")
{
model.SSLBSX = decimal.Parse(row["SSLBSX"].ToString());
}
if (row["SSLBSM"] != null)
{
model.SSLBSM = row["SSLBSM"].ToString();
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.XT_DZJZ_SSLB GetModel(string SSLBBM)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select SSLBBM,FSSLBBM,SSLBLX,SSLBMC,SSLBSX,SSLBSM from XT_DZJZ_SSLB ");
strSql.Append(" where SSLBBM=:SSLBBM ");
OracleParameter[] parameters =
{
new OracleParameter(":SSLBBM", OracleType.Char, 13)
};
parameters[0].Value = SSLBBM;
EDRS.Model.XT_DZJZ_SSLB model = new EDRS.Model.XT_DZJZ_SSLB();
try
{
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
}
catch (Exception ex)
{
EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public EDRS.Model.XT_DZJZ_SSLB GetModel(string SSLBBM)", "EDRS.OracleDAL.XT_DZJZ_SSLB", strSql.ToString());
}
return(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_DZJZ_SSLB bll = new XT_DZJZ_SSLB(this.Request);
EDRS.Model.XT_DZJZ_SSLB model = bll.GetModel(ajlbbm);
string lbbm = string.Empty;
if (model != null)
{
lbbm = model.SSLBBM;
model.SSLBMC = Request.Form.Get("txt_name");
model.SSLBSX = Convert.ToDecimal(Request.Form.Get("txt_sx"));
model.SSLBSM = Request.Form.Get("txt_sm");
if (bll.Update(model))
{
System.Collections.Hashtable hssql = new System.Collections.Hashtable();
hssql.Add(string.Format("update xy_dzjz_mbpzb set sslbmc='{0}',DossierTypeDisplayMember='{0}' where sslbbm='{1}'", model.SSLBMC, lbbm), null);
XY_DZJZ_MBPZB bllmb = new XY_DZJZ_MBPZB(this.Request);
bllmb.Update(hssql);
//数据日志
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>
public bool Update(EDRS.Model.XT_DZJZ_SSLB model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update XT_DZJZ_SSLB set ");
strSql.Append("FSSLBBM=:FSSLBBM,");
strSql.Append("SSLBLX=:SSLBLX,");
strSql.Append("SSLBMC=:SSLBMC,");
strSql.Append("SSLBSX=:SSLBSX,");
strSql.Append("SSLBSM=:SSLBSM");
strSql.Append(" where SSLBBM=:SSLBBM ");
OracleParameter[] parameters =
{
new OracleParameter(":FSSLBBM", OracleType.Char, 13),
new OracleParameter(":SSLBLX", OracleType.Char, 1),
new OracleParameter(":SSLBMC", OracleType.VarChar, 300),
new OracleParameter(":SSLBSX", OracleType.Number, 8),
new OracleParameter(":SSLBSM", OracleType.VarChar, 4000),
new OracleParameter(":SSLBBM", OracleType.Char, 13)
};
parameters[0].Value = model.FSSLBBM;
parameters[1].Value = model.SSLBLX;
parameters[2].Value = model.SSLBMC;
parameters[3].Value = model.SSLBSX;
parameters[4].Value = model.SSLBSM;
parameters[5].Value = model.SSLBBM;
try
{
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
}
catch (Exception ex)
{
EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool Update(EDRS.Model.XT_DZJZ_SSLB model)", "EDRS.OracleDAL.XT_DZJZ_SSLB", strSql.ToString(), parameters);
}
return(false);
}
/// <summary>
/// 根据类别编号获取数据
/// </summary>
/// <param name="DWBM"></param>
/// <returns></returns>
private string GetModel(string sslbbm)
{
if (string.IsNullOrEmpty(sslbbm))
{
sslbbm = Request.Form.Get("id");
if (string.IsNullOrEmpty(sslbbm))
{
return(ReturnString.JsonToString(Prompt.error, "参数错误", null));
}
}
XT_DZJZ_SSLB bll = new XT_DZJZ_SSLB(this.Request);
EDRS.Model.XT_DZJZ_SSLB model = bll.GetModel(sslbbm);
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 AddData()
{
string msg = string.Empty;
if (!ProvingFrom(ref msg))
{
return(ReturnString.JsonToString(Prompt.error, msg, null));
}
string whereValue = String.Empty;
string lx = Request.Form.Get("slct_type_val");
if (lx == "1")
{
whereValue = "000000-";
}
else if (lx == "2")
{
whereValue = "000001-";
}
else if (lx == "3")
{
whereValue = "000002-";
}
else
{
return(ReturnString.JsonToString(Prompt.error, "类型选择错误，请刷新页面重试！", null));
}
XT_DZJZ_SSLB bll = new XT_DZJZ_SSLB(this.Request);
DataSet ds = bll.GetListByPage(" and sslbbm like '" + whereValue + "%' ", "sslbbm desc", 1, 1, null);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
//0101 000000-000000
int num = int.Parse(ds.Tables[0].Rows[0]["SSLBBM"].ToString().Substring(7, 6));
num++;
whereValue += num.ToString().PadLeft(6, '0');
}
else
{
whereValue += "000000";
}
EDRS.Model.XT_DZJZ_SSLB model = new EDRS.Model.XT_DZJZ_SSLB();
model.SSLBBM = whereValue;
model.SSLBLX = lx;
model.SSLBMC = Request.Form["txt_name"];
model.SSLBSX = Convert.ToDecimal(Request.Form["txt_sx"]);
model.SSLBSM = Request.Form["txt_sm"];
model.FSSLBBM = Request.Form["key_fhidd"];
//LogHelper.LogError(Request, "id:" + model.SSLBBM + ",Fid:" + model.FSSLBBM, " 1", "测试1");
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));
}
