public T_BillingApplication GetModelByTruckCode(string strTruckCode)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(sql);
strSql.Append(" where TruckCode=@TruckCode ");
SqlParameter[] parameters =
{
new SqlParameter("@TruckCode", SqlDbType.NVarChar, 50)
};
parameters[0].Value = strTruckCode;
T_BillingApplication model = new T_BillingApplication();
using (SqlDataReader dr = DataHelper.GetDataReader(strSql.ToString(), parameters))
{
if (dr.Read())
{
model.Code = dr["Code"].ToString();
model.AttachmentUrl = dr["AttachmentUrl"].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.Note9 = dr["Note9"].ToString();
model.BillMainCode = dr["BillMainCode"].ToString();
model.Note10 = dr["Note10"].ToString();
model.TruckCode = dr["TruckCode"].ToString();
model.SaleDeptCode = dr["SaleDeptCode"].ToString();
model.AppDate = dr["AppDate"].ToString();
model.SysPersionCode = dr["SysPersionCode"].ToString();
model.SysDateTime = dr["SysDateTime"].ToString();
model.Explain = dr["Explain"].ToString();
model.IsJC = dr["IsJC"].ToString();
model.InvoiceCode = dr["InvoiceCode"].ToString();
model.BillingDate = dr["BillingDate"].ToString();
model.BIllingSysTime = dr["BIllingSysTime"].ToString();
model.DealersName = dr["DealersName"].ToString();
model.IsSpApp = dr["IsSpApp"].ToString();
return(model);
}
else
{
return(null);
}
}
}
public void Add(T_BillingApplication model)
{
using (SqlConnection conn = new SqlConnection(DataHelper.constr))
{
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
Delete(model.Code, tran);
Add(model, tran);
tran.Commit();
}
catch
{
tran.Rollback();
throw;
}
}
}
public IList <T_BillingApplication> ListMaker(string tempsql, SqlParameter[] sps)
{
DataTable dt = DataHelper.GetDataTable(tempsql, sps, false);
IList <T_BillingApplication> list = new List <T_BillingApplication>();
foreach (DataRow dr in dt.Rows)
{
T_BillingApplication model = new T_BillingApplication();
model.Code = dr["Code"].ToString();
model.AttachmentUrl = dr["AttachmentUrl"].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.Note9 = dr["Note9"].ToString();
model.BillMainCode = dr["BillMainCode"].ToString();
model.Note10 = dr["Note10"].ToString();
model.TruckCode = dr["TruckCode"].ToString();
model.SaleDeptCode = dr["SaleDeptCode"].ToString();
model.AppDate = dr["AppDate"].ToString();
model.SysPersionCode = dr["SysPersionCode"].ToString();
model.SysDateTime = dr["SysDateTime"].ToString();
model.Explain = dr["Explain"].ToString();
model.IsJC = dr["IsJC"].ToString();
model.InvoiceCode = dr["InvoiceCode"].ToString();
model.BillingDate = dr["BillingDate"].ToString();
model.BIllingSysTime = dr["BIllingSysTime"].ToString();
model.DealersName = dr["DealersName"].ToString();
model.IsSpApp = dr["IsSpApp"].ToString();
list.Add(model);
}
return(list);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(T_BillingApplication model, SqlTransaction tran)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_BillingApplication(");
strSql.Append("Code,AttachmentUrl,Note1,Note2,Note3,Note4,Note5,Note6,Note7,Note8,Note9,BillMainCode,Note10,TruckCode,SaleDeptCode,AppDate,SysPersionCode,SysDateTime,Explain,IsJC,InvoiceCode,BillingDate,BIllingSysTime,DealersName,IsSpApp");
strSql.Append(") values (");
strSql.Append("@Code,@AttachmentUrl,@Note1,@Note2,@Note3,@Note4,@Note5,@Note6,@Note7,@Note8,@Note9,@BillMainCode,@Note10,@TruckCode,@SaleDeptCode,@AppDate,@SysPersionCode,@SysDateTime,@Explain,@IsJC,@InvoiceCode,@BillingDate,@BIllingSysTime,@DealersName,@IsSpApp");
strSql.Append(") ");
SqlParameter[] parameters =
{
new SqlParameter("@Code", SqlDbType.NVarChar, 50),
new SqlParameter("@AttachmentUrl", SqlDbType.NVarChar, 100),
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("@Note7", SqlDbType.NVarChar, 50),
new SqlParameter("@Note8", SqlDbType.NVarChar, 50),
new SqlParameter("@Note9", SqlDbType.NVarChar, 50),
new SqlParameter("@BillMainCode", SqlDbType.NVarChar, 50),
new SqlParameter("@Note10", SqlDbType.NVarChar, 50),
new SqlParameter("@TruckCode", SqlDbType.NVarChar, 50),
new SqlParameter("@SaleDeptCode", SqlDbType.NVarChar, 50),
new SqlParameter("@AppDate", SqlDbType.NVarChar, 50),
new SqlParameter("@SysPersionCode", SqlDbType.NVarChar, 50),
new SqlParameter("@SysDateTime", SqlDbType.NVarChar, 50),
new SqlParameter("@Explain", SqlDbType.NVarChar, 500),
new SqlParameter("@IsJC", SqlDbType.Char, 1),
new SqlParameter("@InvoiceCode", SqlDbType.NVarChar, 50),
new SqlParameter("@BillingDate", SqlDbType.Char, 10),
new SqlParameter("@BIllingSysTime", SqlDbType.NVarChar, 30),
new SqlParameter("@DealersName", SqlDbType.NVarChar, 50),
new SqlParameter("@IsSpApp", SqlDbType.Char, 1),
};
parameters[0].Value = SqlNull(model.Code);
parameters[1].Value = SqlNull(model.AttachmentUrl);
parameters[2].Value = SqlNull(model.Note1);
parameters[3].Value = SqlNull(model.Note2);
parameters[4].Value = SqlNull(model.Note3);
parameters[5].Value = SqlNull(model.Note4);
parameters[6].Value = SqlNull(model.Note5);
parameters[7].Value = SqlNull(model.Note6);
parameters[8].Value = SqlNull(model.Note7);
parameters[9].Value = SqlNull(model.Note8);
parameters[10].Value = SqlNull(model.Note9);
parameters[11].Value = SqlNull(model.BillMainCode);
parameters[12].Value = SqlNull(model.Note10);
parameters[13].Value = SqlNull(model.TruckCode);
parameters[14].Value = SqlNull(model.SaleDeptCode);
parameters[15].Value = SqlNull(model.AppDate);
parameters[16].Value = SqlNull(model.SysPersionCode);
parameters[17].Value = SqlNull(model.SysDateTime);
parameters[18].Value = SqlNull(model.Explain);
parameters[19].Value = SqlNull(model.IsJC);
parameters[20].Value = SqlNull(model.InvoiceCode);
parameters[21].Value = SqlNull(model.BillingDate);
parameters[22].Value = SqlNull(model.BIllingSysTime);
parameters[23].Value = SqlNull(model.DealersName);
parameters[24].Value = SqlNull(model.IsSpApp);
DataHelper.ExcuteNonQuery(strSql.ToString(), tran, parameters, false);
}