/// <summary>
/// 添加配置数据
/// </summary>
/// <returns></returns>
private string AddData()
{
string msg = string.Empty;
//if (!ProvingFrom(ref msg))
//{
// return ReturnString.JsonToString(Prompt.error, msg, null);
//}
YX_DZJZ_FMDYMB bll = new YX_DZJZ_FMDYMB(this.Request);
EDRS.Model.YX_DZJZ_FMDYMB model = new EDRS.Model.YX_DZJZ_FMDYMB();
model.BT = Request.Form.Get("title");
model.NR = Request.Form.Get("value");
model.CZRGH = "";
model.CZR = "";
model.CZSJ = DateTime.Now;
model.CZIP = Request.ServerVariables["REMOTE_ADDR"];
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>
public bool Update(EDRS.Model.YX_DZJZ_FMDYMB model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update YX_DZJZ_FMDYMB set ");
strSql.Append("BT=:BT,");
strSql.Append("SFMR=:SFMR,");
strSql.Append("CZRGH=:CZRGH,");
strSql.Append("CZR=:CZR,");
strSql.Append("CZSJ=:CZSJ,");
strSql.Append("CZIP=:CZIP,");
strSql.Append("SFSC=:SFSC,");
strSql.Append("NR=:NR");
strSql.Append(" where BM=:BM ");
OracleParameter[] parameters =
{
new OracleParameter(":BT", OracleType.VarChar, 500),
new OracleParameter(":SFMR", OracleType.Char, 1),
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(":SFSC", OracleType.Char, 1),
new OracleParameter(":BM", OracleType.NVarChar),
new OracleParameter(":NR", OracleType.VarChar, 4000)
};
parameters[0].Value = model.BT;
parameters[1].Value = model.SFMR;
parameters[2].Value = model.CZRGH;
parameters[3].Value = model.CZR;
parameters[4].Value = model.CZSJ;
parameters[5].Value = model.CZIP;
parameters[6].Value = model.SFSC;
parameters[7].Value = model.BM;
parameters[8].Value = model.NR;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.YX_DZJZ_FMDYMB DataRowToModel(DataRow row)
{
EDRS.Model.YX_DZJZ_FMDYMB model = new EDRS.Model.YX_DZJZ_FMDYMB();
if (row != null)
{
if (row["BM"] != null)
{
model.BM = row["BM"].ToString();
}
if (row["BT"] != null)
{
model.BT = row["BT"].ToString();
}
if (row["NR"] != null)
{
model.NR = row["NR"].ToString();
}
if (row["SFMR"] != null)
{
model.SFMR = row["SFMR"].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["SFSC"] != null)
{
model.SFSC = row["SFSC"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(EDRS.Model.YX_DZJZ_FMDYMB model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into YX_DZJZ_FMDYMB(");
strSql.Append("BT,SFMR,CZRGH,CZR,CZSJ,CZIP,SFSC,NR)");
strSql.Append(" values (");
strSql.Append(":BT,:SFMR,:CZRGH,:CZR,:CZSJ,:CZIP,:SFSC,:NR)");
OracleParameter[] parameters =
{
new OracleParameter(":BT", OracleType.VarChar, 500),
new OracleParameter(":SFMR", OracleType.Char, 1),
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(":SFSC", OracleType.Char, 1),
new OracleParameter(":NR", OracleType.VarChar, 4000)
};
parameters[0].Value = model.BT;
parameters[1].Value = model.SFMR;
parameters[2].Value = model.CZRGH;
parameters[3].Value = model.CZR;
parameters[4].Value = model.CZSJ;
parameters[5].Value = model.CZIP;
parameters[6].Value = model.SFSC;
parameters[7].Value = model.NR;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.YX_DZJZ_FMDYMB GetModel(string BM)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select BM,BT,SFMR,CZRGH,CZR,CZSJ,CZIP,SFSC,NR from YX_DZJZ_FMDYMB ");
strSql.Append(" where BM=:BM ");
OracleParameter[] parameters =
{
new OracleParameter(":BM", OracleType.NVarChar)
};
parameters[0].Value = BM;
EDRS.Model.YX_DZJZ_FMDYMB model = new EDRS.Model.YX_DZJZ_FMDYMB();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
