/// <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); }