public int InvioceSelect(String invoiceNumber, String invoiceCode) { String sql = String.Format(@" select a.id from dbo.zw_t_pjkcd a INNER JOIN dbo.zw_t_pjxxb b ON a.id=b.rkid WHERE b.fpdm='{0}' AND b.pjh='{1}'", invoiceNumber, invoiceCode); nrWebClass.LiLanzDAL dal = new nrWebClass.LiLanzDAL(); int i = dal.ExecuteNonQuery(sql); return(i); }
public int InvioceVoid(int id, String invoiceNumber, String invoiceCode) { String sql = String.Format(@"UPDATE yx_t_fpxxb SET shbs=0,shr='',shrq=getdate(),fph='',fpdm='',fpzdr='' where shbs=1 and id={2}; update a set djbs=0,djzt=1 from zw_t_pjxxb a inner join zw_t_pjkcd b on a.rkid=b.id and b.shbs=1 where a.pjh='{0}' and a.fpdm='{1}' ", invoiceNumber, invoiceCode, id); nrWebClass.LiLanzDAL dal = new nrWebClass.LiLanzDAL(); int i = dal.ExecuteNonQuery(sql); return(i); }
public int InvioceUpdate(int id, DateTime invioceDate, String sn, String invoiceCode, string printer, double Amount, double TaxAmount) { String sql = String.Format(@"declare @hsje decimal(10,2),@sje decimal(10,2),@khmc varchar(100); select @hsje=sum(b.je),@sje=sum(round(b.je,2)-ROUND(b.je/1.17,2)),@khmc=max(f.zhmc) FROM dbo.yx_t_fpxxb a INNER JOIN dbo.yx_t_fpxxmxb b ON a.id=b.id inner join zw_t_yhzlb f on a.khid=f.id WHERE a.id='{4}'; UPDATE yx_t_fpxxb SET kprq='{0}', fph='{1}', fpdm='{2}',fpzdr='{3}' where id={4}; update a set djbs=1,djzt=1,hsje={5},sbl=0.17,sje={6},khmc=@khmc,kprq='{0}' from zw_t_pjxxb a inner join zw_t_pjkcd b on a.rkid=b.id and b.shbs=1 where a.pjh='{1}' and a.fpdm='{2}' ", invioceDate, sn, invoiceCode, printer, id, Amount, TaxAmount); nrWebClass.LiLanzDAL dal = new nrWebClass.LiLanzDAL(); int i = dal.ExecuteNonQuery(sql); return(i); }