/// <summary> /// 得到一个对象实体 /// </summary> public T_SpecialRebatesStandardmodel GetModel(long NID) { StringBuilder strSql = new StringBuilder(); strSql.Append(sql); strSql.Append(" where NID=@NID"); SqlParameter[] parameters = { new SqlParameter("@NID", SqlDbType.BigInt) }; parameters[0].Value = NID; T_SpecialRebatesStandardmodel model = new T_SpecialRebatesStandardmodel(); using (SqlDataReader dr = DataHelper.GetDataReader(strSql.ToString(), parameters)) { if (dr.Read()) { if (!DBNull.Value.Equals(dr["NID"])) { model.NID = long.Parse(dr["NID"].ToString()); } model.MarkerCode = dr["MarkerCode"].ToString(); model.Status = dr["Status"].ToString(); model.Type = dr["Type"].ToString(); model.SysUserCode = dr["SysUserCode"].ToString(); model.SysTime = dr["SysTime"].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.AppBillCode = dr["AppBillCode"].ToString(); model.Note7 = dr["Note7"].ToString(); model.Note8 = dr["Note8"].ToString(); model.Note9 = dr["Note9"].ToString(); model.Note10 = dr["Note10"].ToString(); model.TruckCode = dr["TruckCode"].ToString(); model.TruckTypeCode = dr["TruckTypeCode"].ToString(); model.DeptCode = dr["DeptCode"].ToString(); model.SaleFeeTypeCode = dr["SaleFeeTypeCode"].ToString(); model.SaleProcessCode = dr["SaleProcessCode"].ToString(); model.ControlItemCode = dr["ControlItemCode"].ToString(); if (!DBNull.Value.Equals(dr["Fee"])) { model.Fee = decimal.Parse(dr["Fee"].ToString()); } return(model); } else { return(null); } } }
public int Add(T_SpecialRebatesStandardmodel model) { using (SqlConnection conn = new SqlConnection(DataHelper.constr)) { conn.Open(); SqlTransaction tran = conn.BeginTransaction(); try { int row = Add(model, tran); tran.Commit(); return(row); } catch { tran.Rollback(); throw; } } }
public IList <T_SpecialRebatesStandardmodel> ListMaker(string tempsql, SqlParameter[] sps) { DataTable dt = DataHelper.GetDataTable(tempsql, sps, false); IList <T_SpecialRebatesStandardmodel> list = new List <T_SpecialRebatesStandardmodel>(); foreach (DataRow dr in dt.Rows) { T_SpecialRebatesStandardmodel model = new T_SpecialRebatesStandardmodel(); if (!DBNull.Value.Equals(dr["NID"])) { model.NID = long.Parse(dr["NID"].ToString()); } model.MarkerCode = dr["MarkerCode"].ToString(); model.Status = dr["Status"].ToString(); model.Type = dr["Type"].ToString(); model.SysUserCode = dr["SysUserCode"].ToString(); model.SysTime = dr["SysTime"].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.AppBillCode = dr["AppBillCode"].ToString(); model.Note7 = dr["Note7"].ToString(); model.Note8 = dr["Note8"].ToString(); model.Note9 = dr["Note9"].ToString(); model.Note10 = dr["Note10"].ToString(); model.TruckCode = dr["TruckCode"].ToString(); model.TruckTypeCode = dr["TruckTypeCode"].ToString(); model.DeptCode = dr["DeptCode"].ToString(); model.SaleFeeTypeCode = dr["SaleFeeTypeCode"].ToString(); model.SaleProcessCode = dr["SaleProcessCode"].ToString(); model.ControlItemCode = dr["ControlItemCode"].ToString(); if (!DBNull.Value.Equals(dr["Fee"])) { model.Fee = decimal.Parse(dr["Fee"].ToString()); } list.Add(model); } return(list); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(T_SpecialRebatesStandardmodel model, SqlTransaction tran) { //Delete(model.NID, tran); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_SpecialRebatesStandard("); strSql.Append("MarkerCode,Status,SysUserCode,SysTime,Note1,Note2,Note3,Note4,Note5,Note6,AppBillCode,Note7,Note8,Note9,Note10,TruckCode,TruckTypeCode,DeptCode,SaleFeeTypeCode,SaleProcessCode,ControlItemCode,Fee,[Type]"); strSql.Append(") values ("); strSql.Append("@MarkerCode,@Status,@SysUserCode,@SysTime,@Note1,@Note2,@Note3,@Note4,@Note5,@Note6,@AppBillCode,@Note7,@Note8,@Note9,@Note10,@TruckCode,@TruckTypeCode,@DeptCode,@SaleFeeTypeCode,@SaleProcessCode,@ControlItemCode,@Fee,@Type"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@MarkerCode", SqlDbType.NVarChar, 50), new SqlParameter("@Status", SqlDbType.NVarChar, 50), new SqlParameter("@SysUserCode", SqlDbType.NVarChar, 50), new SqlParameter("@SysTime", SqlDbType.NVarChar, 20), new SqlParameter("@Note1", SqlDbType.NVarChar, 50), new SqlParameter("@Note2", SqlDbType.NVarChar, 50), new SqlParameter("@Note3", SqlDbType.NVarChar, 50), new SqlParameter("@Note4", SqlDbType.NVarChar, 50), new SqlParameter("@Note5", SqlDbType.NVarChar, 50), new SqlParameter("@Note6", SqlDbType.NVarChar, 50), new SqlParameter("@AppBillCode", SqlDbType.NVarChar, 50), new SqlParameter("@Note7", SqlDbType.NVarChar, 50), new SqlParameter("@Note8", SqlDbType.NVarChar, 50), new SqlParameter("@Note9", SqlDbType.NVarChar, 50), new SqlParameter("@Note10", SqlDbType.NVarChar, 50), new SqlParameter("@TruckCode", SqlDbType.NVarChar, 50), new SqlParameter("@TruckTypeCode", SqlDbType.NVarChar, 50), new SqlParameter("@DeptCode", SqlDbType.NVarChar, 50), new SqlParameter("@SaleFeeTypeCode", SqlDbType.NVarChar, 50), new SqlParameter("@SaleProcessCode", SqlDbType.NVarChar, 50), new SqlParameter("@ControlItemCode", SqlDbType.NVarChar, 50), new SqlParameter("@Fee", SqlDbType.Decimal, 9), new SqlParameter("@Type", SqlDbType.Char, 1) }; parameters[0].Value = SqlNull(model.MarkerCode); parameters[1].Value = SqlNull(model.Status); parameters[2].Value = SqlNull(model.SysUserCode); parameters[3].Value = SqlNull(model.SysTime); parameters[4].Value = SqlNull(model.Note1); parameters[5].Value = SqlNull(model.Note2); parameters[6].Value = SqlNull(model.Note3); parameters[7].Value = SqlNull(model.Note4); parameters[8].Value = SqlNull(model.Note5); parameters[9].Value = SqlNull(model.Note6); parameters[10].Value = SqlNull(model.AppBillCode); parameters[11].Value = SqlNull(model.Note7); parameters[12].Value = SqlNull(model.Note8); parameters[13].Value = SqlNull(model.Note9); parameters[14].Value = SqlNull(model.Note10); parameters[15].Value = SqlNull(model.TruckCode); parameters[16].Value = SqlNull(model.TruckTypeCode); parameters[17].Value = SqlNull(model.DeptCode); parameters[18].Value = SqlNull(model.SaleFeeTypeCode); parameters[19].Value = SqlNull(model.SaleProcessCode); parameters[20].Value = SqlNull(model.ControlItemCode); parameters[21].Value = SqlNull(model.Fee); parameters[22].Value = SqlNull(model.Type); return(DataHelper.ExcuteNonQuery(strSql.ToString(), tran, parameters, false)); }