public void EditUpdateSetBill1(BOLSetBillDate setbillBOL, string sql)
{
using (con = dbaccess.GetConnection())
{
SqlCommand cmd = new SqlCommand();
SqlParameter ptid, pcompanycode, pplantcode, pfrmdate, paymentflag, ptodate, pupdate, pview, pstatus, pdescrip;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = sql;
cmd.Connection = con;
int inser1;
ptid = cmd.Parameters.Add("@tid", SqlDbType.Int);
pcompanycode = cmd.Parameters.Add("@companycode", SqlDbType.NVarChar, 30);
pplantcode = cmd.Parameters.Add("@plantcode", SqlDbType.NVarChar, 30);
pfrmdate = cmd.Parameters.Add("@frmdate", SqlDbType.DateTime);
ptodate = cmd.Parameters.Add("@todate", SqlDbType.DateTime);
paymentflag = cmd.Parameters.Add("@paymetflag", SqlDbType.Int);
pupdate = cmd.Parameters.Add("@update", SqlDbType.Int);
pview = cmd.Parameters.Add("@view ", SqlDbType.Int);
pstatus = cmd.Parameters.Add("@status ", SqlDbType.Int);
pdescrip = cmd.Parameters.Add("@descrip", SqlDbType.NVarChar, 100);
ptid.Value = setbillBOL.Tid;
pcompanycode.Value = setbillBOL.Companycode;
pplantcode.Value = setbillBOL.Plantcode;
pfrmdate.Value = setbillBOL.Billfromdate;
ptodate.Value = setbillBOL.Billtodate;
paymentflag.Value = setbillBOL.PaymentFlag;
pupdate.Value = setbillBOL.Updatestatus;
pview.Value = setbillBOL.Viewstatus;
pstatus.Value = setbillBOL.Status;
pdescrip.Value = setbillBOL.Descriptions;
inser1 = cmd.ExecuteNonQuery();
if (inser1 == 1)
{
i++;
}
else
{
i++;
}
}
}
public void EditUpdateSetBill(BOLSetBillDate SetbillBOL)
{
sqlstr = "Update_EditSetBilldate";
Dalsbilldate.EditUpdateSetBill1(SetbillBOL, sqlstr);
}