public int Insert(TPDATaskBankInfo model) { StringBuilder sb = new StringBuilder(300); sb.Append(@"insert into TPDA_TaskBank (TB_cid,TB_date,TB_Rno,TB_BNO,TB_Bname,TB_Ptime,TB_boxNum,TB_notes,TB_oper,TB_opTime,TB_State,TB_Type,TB_Stime,TB_Etime,TB_Tlen,TB_KilM,TB_Fee,TB_Wxs,TB_Emp,TB_CNO) values (@TBcid,@TBdate,@TBRno,@TBBNO,@TBBname,@TBPtime,@TBboxNum,@TBnotes,@TBoper,@TBopTime,@TBState,@TBType,@TBStime,@TBEtime,@TBTlen,@TBKilM,@TBFee,@TBWxs,@TBEmp,@TBCNO) " ); SqlParameter[] parms = { new SqlParameter("@TBcid", SqlDbType.Char, 2), new SqlParameter("@TBdate", SqlDbType.Char, 10), new SqlParameter("@TBRno", SqlDbType.VarChar, 10), new SqlParameter("@TBBNO", SqlDbType.VarChar, 10), new SqlParameter("@TBBname", SqlDbType.VarChar, 30), new SqlParameter("@TBPtime", SqlDbType.VarChar, 5), new SqlParameter("@TBboxNum", SqlDbType.Int), new SqlParameter("@TBnotes", SqlDbType.VarChar, 255), new SqlParameter("@TBoper", SqlDbType.VarChar, 10), new SqlParameter("@TBopTime", SqlDbType.DateTime), new SqlParameter("@TBState", SqlDbType.Char, 1), new SqlParameter("@TBType", SqlDbType.Char, 1), new SqlParameter("@TBStime", SqlDbType.VarChar, 10), new SqlParameter("@TBEtime", SqlDbType.VarChar, 10), new SqlParameter("@TBTlen", SqlDbType.Decimal), new SqlParameter("@TBKilM", SqlDbType.Int), new SqlParameter("@TBFee", SqlDbType.Int), new SqlParameter("@TBWxs", SqlDbType.Int), new SqlParameter("@TBEmp", SqlDbType.VarChar, 20), new SqlParameter("@TBCNO", SqlDbType.VarChar, 20) }; parms[0].Value = model.TBcid; parms[1].Value = model.TBdate; parms[2].Value = model.TBRno; parms[3].Value = model.TBBNO; parms[4].Value = model.TBBname; parms[5].Value = model.TBPtime; parms[6].Value = model.TBboxNum; parms[7].Value = model.TBnotes; parms[8].Value = model.TBoper; parms[9].Value = model.TBopTime; parms[10].Value = model.TBState; parms[11].Value = model.TBType; parms[12].Value = model.TBStime; parms[13].Value = model.TBEtime; parms[14].Value = model.TBTlen; parms[15].Value = model.TBKilM; parms[16].Value = model.TBFee; parms[17].Value = model.TBWxs; parms[18].Value = model.TBEmp; parms[19].Value = model.TBCNO; return(SqlHelper.ExecuteNonQuery(SqlHelper.QdhtyyDbConnString, CommandType.Text, sb.ToString(), parms)); }
public IList <TPDATaskBankInfo> GetList(int pageIndex, int pageSize, string sqlWhere, params SqlParameter[] cmdParms) { StringBuilder sb = new StringBuilder(500); int startIndex = (pageIndex - 1) * pageSize + 1; int endIndex = pageIndex * pageSize; sb.Append(@"select * from(select row_number() over(order by TB_cid) as RowNumber, TB_cid,TB_date,TB_Rno,TB_BNO,TB_Bname,TB_Ptime,TB_boxNum,TB_notes,TB_oper,TB_opTime,TB_State,TB_Type,TB_Stime,TB_Etime,TB_Tlen,TB_KilM,TB_Fee,TB_Wxs,TB_Emp,TB_CNO from TPDA_TaskBank " ); if (!string.IsNullOrEmpty(sqlWhere)) { sb.AppendFormat(" where 1=1 {0} ", sqlWhere); } sb.AppendFormat(@")as objTable where RowNumber between {0} and {1} ", startIndex, endIndex); IList <TPDATaskBankInfo> list = new List <TPDATaskBankInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.QdhtyyDbConnString, CommandType.Text, sb.ToString(), cmdParms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { TPDATaskBankInfo model = new TPDATaskBankInfo(); model.TBcid = reader.IsDBNull(1) ? string.Empty : reader.GetString(1); model.TBdate = reader.IsDBNull(2) ? string.Empty : reader.GetString(2); model.TBRno = reader.IsDBNull(3) ? string.Empty : reader.GetString(3); model.TBBNO = reader.IsDBNull(4) ? string.Empty : reader.GetString(4); model.TBBname = reader.IsDBNull(5) ? string.Empty : reader.GetString(5); model.TBPtime = reader.IsDBNull(6) ? string.Empty : reader.GetString(6); model.TBboxNum = reader.IsDBNull(7) ? 0 : reader.GetInt32(7); model.TBnotes = reader.IsDBNull(8) ? string.Empty : reader.GetString(8); model.TBoper = reader.IsDBNull(9) ? string.Empty : reader.GetString(9); model.TBopTime = reader.IsDBNull(10) ? DateTime.Parse("1754-01-01") : reader.GetDateTime(10); model.TBState = reader.IsDBNull(11) ? string.Empty : reader.GetString(11); model.TBType = reader.IsDBNull(12) ? string.Empty : reader.GetString(12); model.TBStime = reader.IsDBNull(13) ? string.Empty : reader.GetString(13); model.TBEtime = reader.IsDBNull(14) ? string.Empty : reader.GetString(14); model.TBTlen = reader.IsDBNull(15) ? 0 : reader.GetDecimal(15); model.TBKilM = reader.IsDBNull(16) ? 0 : reader.GetInt32(16); model.TBFee = reader.IsDBNull(17) ? 0 : reader.GetInt32(17); model.TBWxs = reader.IsDBNull(18) ? 0 : reader.GetInt32(18); model.TBEmp = reader.IsDBNull(19) ? string.Empty : reader.GetString(19); model.TBCNO = reader.IsDBNull(20) ? string.Empty : reader.GetString(20); list.Add(model); } } } return(list); }
public IList <TPDATaskBankInfo> GetList(string pid, string pno, string adate) { SqlParameter[] parms = { new SqlParameter("@Adate", adate), new SqlParameter("@PID", pid), new SqlParameter("@PNO", pno) }; var list = new List <TPDATaskBankInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.QdhtyyDbConnString, CommandType.StoredProcedure, "SDP_GetTask", parms)) { if (reader != null && reader.HasRows) { while (reader.Read()) { var model = new TPDATaskBankInfo(); model.TBcid = reader.IsDBNull(0) ? string.Empty : reader.GetString(0); model.TBdate = reader.IsDBNull(1) ? string.Empty : reader.GetString(1); model.TBRno = reader.IsDBNull(2) ? string.Empty : reader.GetString(2); model.TBBNO = reader.IsDBNull(3) ? string.Empty : reader.GetString(3); model.TBBname = reader.IsDBNull(4) ? string.Empty : reader.GetString(4); model.TBPtime = reader.IsDBNull(5) ? string.Empty : reader.GetString(5); model.TBboxNum = reader.IsDBNull(6) ? 0 : reader.GetInt32(6); model.TBnotes = reader.IsDBNull(7) ? string.Empty : reader.GetString(7); model.TBoper = reader.IsDBNull(8) ? string.Empty : reader.GetString(8); model.TBopTime = reader.IsDBNull(9) ? DateTime.Parse("1754-01-01") : reader.GetDateTime(9); model.TBState = reader.IsDBNull(10) ? string.Empty : reader.GetString(10); model.TBType = reader.IsDBNull(11) ? string.Empty : reader.GetString(11); model.TBStime = reader.IsDBNull(12) ? string.Empty : reader.GetString(12); model.TBEtime = reader.IsDBNull(13) ? string.Empty : reader.GetString(13); model.TBTlen = reader.IsDBNull(14) ? 0 : reader.GetDecimal(14); model.TBKilM = reader.IsDBNull(15) ? 0 : reader.GetInt32(15); model.TBFee = reader.IsDBNull(16) ? 0 : reader.GetInt32(16); model.TBWxs = reader.IsDBNull(17) ? 0 : reader.GetInt32(17); model.TBEmp = reader.IsDBNull(18) ? string.Empty : reader.GetString(18); model.TBCNO = reader.IsDBNull(19) ? string.Empty : reader.GetString(19); //if (model.TBState == "1") model.TBState = "已完成"; list.Add(model); } } } return(list); }
public TPDATaskBankInfo GetModel(string tBcid) { TPDATaskBankInfo model = null; StringBuilder sb = new StringBuilder(300); sb.Append(@"select top 1 TB_cid,TB_date,TB_Rno,TB_BNO,TB_Bname,TB_Ptime,TB_boxNum,TB_notes,TB_oper,TB_opTime,TB_State,TB_Type,TB_Stime,TB_Etime,TB_Tlen,TB_KilM,TB_Fee,TB_Wxs,TB_Emp,TB_CNO from TPDA_TaskBank where TB_cid = @TBcid " ); SqlParameter[] parms = { new SqlParameter("@TBcid", SqlDbType.Char, 2) }; parms[0].Value = tBcid; using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.QdhtyyDbConnString, CommandType.Text, sb.ToString(), parms)) { if (reader != null) { if (reader.Read()) { model = new TPDATaskBankInfo(); model.TBcid = reader.IsDBNull(0) ? string.Empty : reader.GetString(0); model.TBdate = reader.IsDBNull(1) ? string.Empty : reader.GetString(1); model.TBRno = reader.IsDBNull(2) ? string.Empty : reader.GetString(2); model.TBBNO = reader.IsDBNull(3) ? string.Empty : reader.GetString(3); model.TBBname = reader.IsDBNull(4) ? string.Empty : reader.GetString(4); model.TBPtime = reader.IsDBNull(5) ? string.Empty : reader.GetString(5); model.TBboxNum = reader.IsDBNull(6) ? 0 : reader.GetInt32(6); model.TBnotes = reader.IsDBNull(7) ? string.Empty : reader.GetString(7); model.TBoper = reader.IsDBNull(8) ? string.Empty : reader.GetString(8); model.TBopTime = reader.IsDBNull(9) ? DateTime.Parse("1754-01-01") : reader.GetDateTime(9); model.TBState = reader.IsDBNull(10) ? string.Empty : reader.GetString(10); model.TBType = reader.IsDBNull(11) ? string.Empty : reader.GetString(11); model.TBStime = reader.IsDBNull(12) ? string.Empty : reader.GetString(12); model.TBEtime = reader.IsDBNull(13) ? string.Empty : reader.GetString(13); model.TBTlen = reader.IsDBNull(14) ? 0 : reader.GetDecimal(14); model.TBKilM = reader.IsDBNull(15) ? 0 : reader.GetInt32(15); model.TBFee = reader.IsDBNull(16) ? 0 : reader.GetInt32(16); model.TBWxs = reader.IsDBNull(17) ? 0 : reader.GetInt32(17); model.TBEmp = reader.IsDBNull(18) ? string.Empty : reader.GetString(18); model.TBCNO = reader.IsDBNull(19) ? string.Empty : reader.GetString(19); } } } return(model); }
public IList <TPDATaskBankInfo> GetList() { StringBuilder sb = new StringBuilder(300); sb.Append(@"select TB_cid,TB_date,TB_Rno,TB_BNO,TB_Bname,TB_Ptime,TB_boxNum,TB_notes,TB_oper,TB_opTime,TB_State,TB_Type,TB_Stime,TB_Etime,TB_Tlen,TB_KilM,TB_Fee,TB_Wxs,TB_Emp,TB_CNO from TPDA_TaskBank order by TB_cid " ); IList <TPDATaskBankInfo> list = new List <TPDATaskBankInfo>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.QdhtyyDbConnString, CommandType.Text, sb.ToString())) { if (reader != null && reader.HasRows) { while (reader.Read()) { TPDATaskBankInfo model = new TPDATaskBankInfo(); model.TBcid = reader.IsDBNull(0) ? string.Empty : reader.GetString(0); model.TBdate = reader.IsDBNull(1) ? string.Empty : reader.GetString(1); model.TBRno = reader.IsDBNull(2) ? string.Empty : reader.GetString(2); model.TBBNO = reader.IsDBNull(3) ? string.Empty : reader.GetString(3); model.TBBname = reader.IsDBNull(4) ? string.Empty : reader.GetString(4); model.TBPtime = reader.IsDBNull(5) ? string.Empty : reader.GetString(5); model.TBboxNum = reader.IsDBNull(6) ? 0 : reader.GetInt32(6); model.TBnotes = reader.IsDBNull(7) ? string.Empty : reader.GetString(7); model.TBoper = reader.IsDBNull(8) ? string.Empty : reader.GetString(8); model.TBopTime = reader.IsDBNull(9) ? DateTime.Parse("1754-01-01") : reader.GetDateTime(9); model.TBState = reader.IsDBNull(10) ? string.Empty : reader.GetString(10); model.TBType = reader.IsDBNull(11) ? string.Empty : reader.GetString(11); model.TBStime = reader.IsDBNull(12) ? string.Empty : reader.GetString(12); model.TBEtime = reader.IsDBNull(13) ? string.Empty : reader.GetString(13); model.TBTlen = reader.IsDBNull(14) ? 0 : reader.GetDecimal(14); model.TBKilM = reader.IsDBNull(15) ? 0 : reader.GetInt32(15); model.TBFee = reader.IsDBNull(16) ? 0 : reader.GetInt32(16); model.TBWxs = reader.IsDBNull(17) ? 0 : reader.GetInt32(17); model.TBEmp = reader.IsDBNull(18) ? string.Empty : reader.GetString(18); model.TBCNO = reader.IsDBNull(19) ? string.Empty : reader.GetString(19); list.Add(model); } } } return(list); }
public int Update(TPDATaskBankInfo model) { return(dal.Update(model)); }
public int Insert(TPDATaskBankInfo model) { return(dal.Insert(model)); }