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