/// <summary>
/// 创建日志
/// </summary>
/// <param name="sysnote">日志主表对象</param>
/// <param name="objMain">单据主表</param>
/// <param name="lstItem">单据</param>k
/// <returns></returns>
public int Create(Sys_Note sysnote, object objMain, List <object> lstItem)
{
int row = 0;
using (SqlConnection conn = new SqlConnection(DataHelper.constr))
{
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
if (objMain != null)
{
sysnote.afterstr = MainStr(objMain);
}
Add(sysnote, tran);
if (lstItem.Count > 0)
{
List <Sys_Notes> lists = ItemListMaker(sysnote.sysCode, lstItem);
AddItems(lists, tran);
}
tran.Commit();
}
catch
{
tran.Rollback();
throw;
}
}
return(row);
}
/// <summary>
///根据查询获取主表对象集合
/// </summary>
/// <param name="tempsql">查询语句</param>
/// <param name="sps">参数</param>
/// <returns>主表对象集合</returns>
public IList <Sys_Note> ListMaker(string tempsql, SqlParameter[] sps)
{
DataTable dt = DataHelper.GetDataTable(tempsql, sps, false);
IList <Sys_Note> list = new List <Sys_Note>();
foreach (DataRow dr in dt.Rows)
{
Sys_Note model = new Sys_Note();
model.sysCode = dr["sysCode"].ToString();
model.afterstr = dr["afterstr"].ToString();
model.opeDiscretion = dr["opeDiscretion"].ToString();
model.note1 = dr["note1"].ToString();
model.note2 = dr["note2"].ToString();
model.note3 = dr["note3"].ToString();
model.note4 = dr["note4"].ToString();
model.note5 = dr["note5"].ToString();
model.note6 = dr["note6"].ToString();
model.note7 = dr["note7"].ToString();
model.note8 = dr["note8"].ToString();
model.billcode = dr["billcode"].ToString();
model.note9 = dr["note9"].ToString();
model.note10 = dr["note10"].ToString();
model.note11 = dr["note11"].ToString();
model.note12 = dr["note12"].ToString();
model.note13 = dr["note13"].ToString();
model.note14 = dr["note14"].ToString();
model.note15 = dr["note15"].ToString();
model.note16 = dr["note16"].ToString();
model.note17 = dr["note17"].ToString();
model.note18 = dr["note18"].ToString();
model.billname = dr["billname"].ToString();
model.note19 = dr["note19"].ToString();
model.note20 = dr["note20"].ToString();
model.usercode = dr["usercode"].ToString();
model.billtype = dr["billtype"].ToString();
model.OperationType = dr["OperationType"].ToString();
model.userip = dr["userip"].ToString();
if (!DBNull.Value.Equals(dr["ndate"]))
{
model.ndate = DateTime.Parse(dr["ndate"].ToString());
}
model.beforestr = dr["beforestr"].ToString();
list.Add(model);
}
return(list);
}
/// <summary>
/// 增加一条主表数据
/// </summary>
public void Add(Sys_Note model, SqlTransaction tran)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Sys_Note(");
strSql.Append("sysCode,afterstr,opeDiscretion,note1,note2,note3,note4,note5,note6,note7,note8,billcode,note9,note10,note11,note12,note13,note14,note15,note16,note17,note18,billname,note19,note20,usercode,billtype,OperationType,userip,ndate,beforestr");
strSql.Append(") values (");
strSql.Append("@sysCode,@afterstr,@opeDiscretion,@note1,@note2,@note3,@note4,@note5,@note6,@note7,@note8,@billcode,@note9,@note10,@note11,@note12,@note13,@note14,@note15,@note16,@note17,@note18,@billname,@note19,@note20,@usercode,@billtype,@OperationType,@userip,@ndate,@beforestr");
strSql.Append(") ");
SqlParameter[] parameters =
{
new SqlParameter("@sysCode", SqlDbType.VarChar, 50),
new SqlParameter("@afterstr", SqlDbType.Text),
new SqlParameter("@opeDiscretion", SqlDbType.Text),
new SqlParameter("@note1", SqlDbType.VarChar, 100),
new SqlParameter("@note2", SqlDbType.VarChar, 100),
new SqlParameter("@note3", SqlDbType.VarChar, 100),
new SqlParameter("@note4", SqlDbType.VarChar, 100),
new SqlParameter("@note5", SqlDbType.VarChar, 100),
new SqlParameter("@note6", SqlDbType.VarChar, 100),
new SqlParameter("@note7", SqlDbType.VarChar, 100),
new SqlParameter("@note8", SqlDbType.VarChar, 100),
new SqlParameter("@billcode", SqlDbType.VarChar, 200),
new SqlParameter("@note9", SqlDbType.VarChar, 100),
new SqlParameter("@note10", SqlDbType.VarChar, 100),
new SqlParameter("@note11", SqlDbType.VarChar, 100),
new SqlParameter("@note12", SqlDbType.VarChar, 100),
new SqlParameter("@note13", SqlDbType.VarChar, 100),
new SqlParameter("@note14", SqlDbType.VarChar, 100),
new SqlParameter("@note15", SqlDbType.VarChar, 100),
new SqlParameter("@note16", SqlDbType.VarChar, 100),
new SqlParameter("@note17", SqlDbType.VarChar, 100),
new SqlParameter("@note18", SqlDbType.VarChar, 100),
new SqlParameter("@billname", SqlDbType.VarChar, 200),
new SqlParameter("@note19", SqlDbType.VarChar, 100),
new SqlParameter("@note20", SqlDbType.VarChar, 100),
new SqlParameter("@usercode", SqlDbType.VarChar, 100),
new SqlParameter("@billtype", SqlDbType.VarChar, 50),
new SqlParameter("@OperationType", SqlDbType.VarChar, 50),
new SqlParameter("@userip", SqlDbType.VarChar, 200),
new SqlParameter("@ndate", SqlDbType.DateTime),
new SqlParameter("@beforestr", SqlDbType.Text)
};
parameters[0].Value = SqlNull(model.sysCode);
parameters[1].Value = SqlNull(model.afterstr);
parameters[2].Value = SqlNull(model.opeDiscretion);
parameters[3].Value = SqlNull(model.note1);
parameters[4].Value = SqlNull(model.note2);
parameters[5].Value = SqlNull(model.note3);
parameters[6].Value = SqlNull(model.note4);
parameters[7].Value = SqlNull(model.note5);
parameters[8].Value = SqlNull(model.note6);
parameters[9].Value = SqlNull(model.note7);
parameters[10].Value = SqlNull(model.note8);
parameters[11].Value = SqlNull(model.billcode);
parameters[12].Value = SqlNull(model.note9);
parameters[13].Value = SqlNull(model.note10);
parameters[14].Value = SqlNull(model.note11);
parameters[15].Value = SqlNull(model.note12);
parameters[16].Value = SqlNull(model.note13);
parameters[17].Value = SqlNull(model.note14);
parameters[18].Value = SqlNull(model.note15);
parameters[19].Value = SqlNull(model.note16);
parameters[20].Value = SqlNull(model.note17);
parameters[21].Value = SqlNull(model.note18);
parameters[22].Value = SqlNull(model.billname);
parameters[23].Value = SqlNull(model.note19);
parameters[24].Value = SqlNull(model.note20);
parameters[25].Value = SqlNull(model.usercode);
parameters[26].Value = SqlNull(model.billtype);
parameters[27].Value = SqlNull(model.OperationType);
parameters[28].Value = SqlNull(model.userip);
parameters[29].Value = SqlNull(model.ndate);
parameters[30].Value = SqlNull(model.beforestr);
DataHelper.ExcuteNonQuery(strSql.ToString(), tran, parameters, false);
}
