/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(EDRS.Model.YX_DZJZ_FMDY model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into YX_DZJZ_FMDY(");
strSql.Append("BT,FBT,AJMC,AJBH,FZXYR,LASJ,JASJ,LJDW,LJR,SHR,BAGJ,DJJ,GJY,CZRGH,CZR,CZSJ,CZIP,CZLX)");
strSql.Append(" values (");
strSql.Append(":BT,:FBT,:AJMC,:AJBH,:FZXYR,:LASJ,:JASJ,:LJDW,:LJR,:SHR,:BAGJ,:DJJ,:GJY,:CZRGH,:CZR,:CZSJ,:CZIP,:CZLX)");
OracleParameter[] parameters =
{
new OracleParameter(":BT", OracleType.VarChar, 500),
new OracleParameter(":FBT", OracleType.VarChar, 500),
new OracleParameter(":AJMC", OracleType.VarChar, 500),
new OracleParameter(":AJBH", OracleType.VarChar, 500),
new OracleParameter(":FZXYR", OracleType.VarChar, 2000),
new OracleParameter(":LASJ", OracleType.DateTime),
new OracleParameter(":JASJ", OracleType.DateTime),
new OracleParameter(":LJDW", OracleType.VarChar, 300),
new OracleParameter(":LJR", OracleType.VarChar, 300),
new OracleParameter(":SHR", OracleType.VarChar, 300),
new OracleParameter(":BAGJ", OracleType.Number, 18),
new OracleParameter(":DJJ", OracleType.VarChar, 50),
new OracleParameter(":GJY", OracleType.Number, 18),
new OracleParameter(":CZRGH", OracleType.Char, 4),
new OracleParameter(":CZR", OracleType.VarChar, 60),
new OracleParameter(":CZSJ", OracleType.DateTime),
new OracleParameter(":CZIP", OracleType.VarChar, 20),
new OracleParameter(":CZLX", OracleType.VarChar, 2)
};
parameters[0].Value = model.BT;
parameters[1].Value = model.FBT;
parameters[2].Value = model.AJMC;
parameters[3].Value = model.AJBH;
parameters[4].Value = model.FZXYR;
parameters[5].Value = model.LASJ ?? (object)DBNull.Value;
parameters[6].Value = model.JASJ ?? (object)DBNull.Value;
parameters[7].Value = model.LJDW;
parameters[8].Value = model.LJR;
parameters[9].Value = model.SHR;
parameters[10].Value = model.BAGJ;
parameters[11].Value = model.DJJ;
parameters[12].Value = model.GJY;
parameters[13].Value = model.CZRGH;
parameters[14].Value = model.CZR;
parameters[15].Value = model.CZSJ;
parameters[16].Value = model.CZIP;
parameters[17].Value = model.CZLX;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 修改配置数据
/// </summary>
/// <returns></returns>
private string UpData()
{
string pzbm = Request.Form.Get("key_hidd").Trim();
if (string.IsNullOrEmpty(pzbm))
{
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
string msg = string.Empty;
if (!ProvingFrom(ref msg))
{
return(ReturnString.JsonToString(Prompt.error, msg, null));
}
YX_DZJZ_FMDY bll = new YX_DZJZ_FMDY(this.Request);
EDRS.Model.YX_DZJZ_FMDY model = bll.GetModel(pzbm);
if (model != null)
{
model.BT = Request.Form.Get("txt_bt");
model.FBT = Request.Form.Get("txt_fbt");
model.AJMC = Request.Form.Get("txt_ajmc");
model.AJBH = Request.Form.Get("txt_ajbh");
model.FZXYR = Request.Form.Get("txt_fzxyr");
if (!string.IsNullOrEmpty(Request.Form.Get("txt_lasj")))
{
model.LASJ = Convert.ToDateTime(Request.Form.Get("txt_lasj"));
}
if (!string.IsNullOrEmpty(Request.Form.Get("txt_jasj")))
{
model.JASJ = Convert.ToDateTime(Request.Form.Get("txt_jasj"));
}
model.LJDW = Request.Form.Get("txt_ljdw");
model.LJR = Request.Form.Get("txt_ljr");
model.SHR = Request.Form.Get("txt_shr");
model.BAGJ = string.IsNullOrEmpty(Request.Form.Get("txt_bagj")) ? 0 : int.Parse(Request.Form.Get("txt_bagj"));
model.DJJ = Request.Form.Get("txt_djj");
model.GJY = string.IsNullOrEmpty(Request.Form.Get("txt_gjy")) ? 0 : int.Parse(Request.Form.Get("txt_gjy"));
model.CZRGH = UserInfo.GH;
model.CZR = UserInfo.MC;
model.CZSJ = DateTime.Now;
model.CZIP = Request.ServerVariables["REMOTE_ADDR"];
model.CZLX = "";
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, "修改方面打印未找到信息", Request.Form.Get("txt_cs"), 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);
//}
YX_DZJZ_FMDY bll = new YX_DZJZ_FMDY(this.Request);
EDRS.Model.YX_DZJZ_FMDY model = new EDRS.Model.YX_DZJZ_FMDY();
model.BT = Request.Form.Get("txt_bt");
model.FBT = Request.Form.Get("txt_fbt");
model.AJMC = Request.Form.Get("txt_ajmc");
model.AJBH = Request.Form.Get("txt_ajbh");
model.FZXYR = Request.Form.Get("txt_fzxyr");
model.LASJ = Convert.ToDateTime(Request.Form.Get("txt_lasj"));
model.JASJ = Convert.ToDateTime(Request.Form.Get("txt_jasj"));
model.LJDW = Request.Form.Get("txt_ljdw");
model.LJR = Request.Form.Get("txt_ljr");
model.SHR = Request.Form.Get("txt_shr");
model.BAGJ = int.Parse(Request.Form.Get("txt_bagj"));
model.DJJ = Request.Form.Get("txt_djj");
model.GJY = int.Parse(Request.Form.Get("txt_gjy"));
model.CZRGH = UserInfo.GH;
model.CZR = UserInfo.MC;
model.CZSJ = DateTime.Now;
model.CZIP = "";
model.CZLX = "";
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 PZBM)
{
if (string.IsNullOrEmpty(PZBM))
{
PZBM = Request["id"];
if (string.IsNullOrEmpty(PZBM))
{
return(ReturnString.JsonToString(Prompt.error, "参数错误", null));
}
}
YX_DZJZ_FMDY bll = new YX_DZJZ_FMDY(this.Request);
EDRS.Model.YX_DZJZ_FMDY model = bll.GetModel(PZBM);
if (model != null)
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "根据编号获取方面打印信息成功", "", UserInfo, UserRole, this.Request);
return(JsonHelper.JsonString(model));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "根据编号获取方面打印信息参数失败", Request["cs"], UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "获取数据失败", null));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.YX_DZJZ_FMDY GetModel(string BM)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select BM,BT,FBT,AJMC,AJBH,FZXYR,LASJ,JASJ,LJDW,LJR,SHR,BAGJ,DJJ,GJY,CZRGH,CZR,CZSJ,CZIP,CZLX from YX_DZJZ_FMDY ");
strSql.Append(" where BM=:BM ");
OracleParameter[] parameters =
{
new OracleParameter(":BM", OracleType.NVarChar)
};
parameters[0].Value = BM;
EDRS.Model.YX_DZJZ_FMDY model = new EDRS.Model.YX_DZJZ_FMDY();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.YX_DZJZ_FMDY DataRowToModel(DataRow row)
{
EDRS.Model.YX_DZJZ_FMDY model = new EDRS.Model.YX_DZJZ_FMDY();
if (row != null)
{
if (row["BM"] != null)
{
model.BM = row["BM"].ToString();
}
if (row["BT"] != null)
{
model.BT = row["BT"].ToString();
}
if (row["FBT"] != null)
{
model.FBT = row["FBT"].ToString();
}
if (row["AJMC"] != null)
{
model.AJMC = row["AJMC"].ToString();
}
if (row["AJBH"] != null)
{
model.AJBH = row["AJBH"].ToString();
}
if (row["FZXYR"] != null)
{
model.FZXYR = row["FZXYR"].ToString();
}
if (row["LASJ"] != null && row["LASJ"].ToString() != "")
{
model.LASJ = DateTime.Parse(row["LASJ"].ToString());
}
if (row["JASJ"] != null && row["JASJ"].ToString() != "")
{
model.JASJ = DateTime.Parse(row["JASJ"].ToString());
}
if (row["LJDW"] != null)
{
model.LJDW = row["LJDW"].ToString();
}
if (row["LJR"] != null)
{
model.LJR = row["LJR"].ToString();
}
if (row["SHR"] != null)
{
model.SHR = row["SHR"].ToString();
}
if (row["BAGJ"] != null && row["BAGJ"].ToString() != "")
{
model.BAGJ = decimal.Parse(row["BAGJ"].ToString());
}
if (row["DJJ"] != null)
{
model.DJJ = row["DJJ"].ToString();
}
if (row["GJY"] != null && row["GJY"].ToString() != "")
{
model.GJY = decimal.Parse(row["GJY"].ToString());
}
if (row["CZRGH"] != null)
{
model.CZRGH = row["CZRGH"].ToString();
}
if (row["CZR"] != null)
{
model.CZR = row["CZR"].ToString();
}
if (row["CZSJ"] != null && row["CZSJ"].ToString() != "")
{
model.CZSJ = DateTime.Parse(row["CZSJ"].ToString());
}
if (row["CZIP"] != null)
{
model.CZIP = row["CZIP"].ToString();
}
if (row["CZLX"] != null)
{
model.CZLX = row["CZLX"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(EDRS.Model.YX_DZJZ_FMDY model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update YX_DZJZ_FMDY set ");
strSql.Append("BT=:BT,");
strSql.Append("FBT=:FBT,");
strSql.Append("AJMC=:AJMC,");
strSql.Append("AJBH=:AJBH,");
strSql.Append("FZXYR=:FZXYR,");
strSql.Append("LASJ=:LASJ,");
strSql.Append("JASJ=:JASJ,");
strSql.Append("LJDW=:LJDW,");
strSql.Append("LJR=:LJR,");
strSql.Append("SHR=:SHR,");
strSql.Append("BAGJ=:BAGJ,");
strSql.Append("DJJ=:DJJ,");
strSql.Append("GJY=:GJY,");
strSql.Append("CZRGH=:CZRGH,");
strSql.Append("CZR=:CZR,");
strSql.Append("CZSJ=:CZSJ,");
strSql.Append("CZIP=:CZIP,");
strSql.Append("CZLX=:CZLX");
strSql.Append(" where BM=:BM ");
OracleParameter[] parameters =
{
new OracleParameter(":BT", OracleType.VarChar, 500),
new OracleParameter(":FBT", OracleType.VarChar, 500),
new OracleParameter(":AJMC", OracleType.VarChar, 500),
new OracleParameter(":AJBH", OracleType.VarChar, 500),
new OracleParameter(":FZXYR", OracleType.VarChar, 2000),
new OracleParameter(":LASJ", OracleType.DateTime),
new OracleParameter(":JASJ", OracleType.DateTime),
new OracleParameter(":LJDW", OracleType.VarChar, 300),
new OracleParameter(":LJR", OracleType.VarChar, 300),
new OracleParameter(":SHR", OracleType.VarChar, 300),
new OracleParameter(":BAGJ", OracleType.Number, 18),
new OracleParameter(":DJJ", OracleType.VarChar, 50),
new OracleParameter(":GJY", OracleType.Number, 18),
new OracleParameter(":CZRGH", OracleType.Char, 4),
new OracleParameter(":CZR", OracleType.VarChar, 60),
new OracleParameter(":CZSJ", OracleType.DateTime),
new OracleParameter(":CZIP", OracleType.VarChar, 20),
new OracleParameter(":CZLX", OracleType.VarChar, 2),
new OracleParameter(":BM", OracleType.NVarChar)
};
parameters[0].Value = model.BT;
parameters[1].Value = model.FBT;
parameters[2].Value = model.AJMC;
parameters[3].Value = model.AJBH;
parameters[4].Value = model.FZXYR;
parameters[5].Value = model.LASJ;
parameters[6].Value = model.JASJ;
parameters[7].Value = model.LJDW;
parameters[8].Value = model.LJR;
parameters[9].Value = model.SHR;
parameters[10].Value = model.BAGJ;
parameters[11].Value = model.DJJ;
parameters[12].Value = model.GJY;
parameters[13].Value = model.CZRGH;
parameters[14].Value = model.CZR;
parameters[15].Value = model.CZSJ;
parameters[16].Value = model.CZIP;
parameters[17].Value = model.CZLX;
parameters[18].Value = model.BM;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
