public object ShowOneJoinDetail(JOIN_BILLEntity Data) { string goodssql = "select S.*,G.GOODSDM,G.NAME from JOIN_BILL_GOODS S,GOODS G where S.GOODSID=G.GOODSID "; if (!Data.BILLID.IsEmpty()) { goodssql += (" and S.BILLID= " + Data.BILLID); } DataTable dtgoods = DbHelper.ExecuteTable(goodssql); string trimsql = " select S.*,F.NAME,F.TYPE from JOIN_BILL_TRINM S,FEESUBJECT F where S.TRIMID=F.TRIMID "; if (!Data.BILLID.IsEmpty()) { goodssql += (" and S.BILLID= " + Data.BILLID); } DataTable dttrim = DbHelper.ExecuteTable(trimsql); var result = new { bill_goods = new dynamic[] { dtgoods }, bill_trim = new dynamic[] { dttrim } }; return(result); }
public object GetJoinBillElement(JOIN_BILLEntity Data) { string sql = $@"SELECT L.*,B.NAME BRANCHNAME,T.NAME MERCHANTNAME, " + " nvl(L.JE_16,0) +nvl(L.ZZSJE_16,0) JSHJ_16,nvl(L.JE_10,0) +nvl(L.ZZSJE_10,0) JSHJ_10,nvl(L.JE_QT,0) +nvl(L.ZZSJE_QT,0) JSHJ_QT," + " nvl(L.JE_16,0)+nvl(L.JE_10,0)+nvl(L.JE_QT,0) JKHJ,nvl(L.ZZSJE_16,0)+nvl(L.ZZSJE_10,0)+nvl(L.ZZSJE_QT,0) ZZSJEHJ," + " nvl(L.JE_16,0)+nvl(L.JE_10,0)+nvl(L.JE_QT,0) + nvl(L.ZZSJE_16,0)+nvl(L.ZZSJE_10,0)+nvl(L.ZZSJE_QT,0) JSHJ, " + " nvl(L.JE_16,0)+nvl(L.JE_10,0)+nvl(L.JE_QT,0) + nvl(L.ZZSJE_16,0)+nvl(L.ZZSJE_10,0)+nvl(L.ZZSJE_QT,0)-nvl(L.KKJE,0) SJFKJE" + " FROM JOIN_BILL L,BRANCH B ,MERCHANT T " + " WHERE L.BRANCHID = B.ID AND L.MERCHANTID = T.MERCHANTID"; if (!Data.BILLID.IsEmpty()) { sql += (" and L.BILLID= " + Data.BILLID); } DataTable dt = DbHelper.ExecuteTable(sql); string goodssql = "select S.*,G.GOODSDM,G.NAME from JOIN_BILL_GOODS S,GOODS G where S.GOODSID=G.GOODSID "; if (!Data.BILLID.IsEmpty()) { goodssql += (" and S.BILLID= " + Data.BILLID); } DataTable dtgoods = DbHelper.ExecuteTable(goodssql); string trimsql = " select S.*,F.NAME,F.TYPE from JOIN_BILL_TRINM S,FEESUBJECT F where S.TRIMID=F.TRIMID "; if (!Data.BILLID.IsEmpty()) { goodssql += (" and S.BILLID= " + Data.BILLID); } DataTable dttrim = DbHelper.ExecuteTable(trimsql); var result = new { joinbill = dt, bill_goods = new dynamic[] { dtgoods }, bill_trim = new dynamic[] { dttrim }, }; return(result); }
public Tuple <dynamic> GetJoinBillDetail(JOIN_BILLEntity Data) { string sql = $@"SELECT L.*,B.NAME BRANCHNAME,T.NAME MERCHANTNAME, " + " nvl(L.JE_16,0) +nvl(L.ZZSJE_16,0) JSHJ_16,nvl(L.JE_10,0) +nvl(L.ZZSJE_10,0) JSHJ_10,nvl(L.JE_QT,0) +nvl(L.ZZSJE_QT,0) JSHJ_QT," + " nvl(L.JE_16,0)+nvl(L.JE_10,0)+nvl(L.JE_QT,0) JKHJ,nvl(L.ZZSJE_16,0)+nvl(L.ZZSJE_10,0)+nvl(L.ZZSJE_QT,0) ZZSJEHJ," + " nvl(L.JE_16,0)+nvl(L.JE_10,0)+nvl(L.JE_QT,0) + nvl(L.ZZSJE_16,0)+nvl(L.ZZSJE_10,0)+nvl(L.ZZSJE_QT,0) JSHJ, " + " nvl(L.JE_16,0)+nvl(L.JE_10,0)+nvl(L.JE_QT,0) + nvl(L.ZZSJE_16,0)+nvl(L.ZZSJE_10,0)+nvl(L.ZZSJE_QT,0)-nvl(L.KKJE,0) SJFKJE" + " FROM JOIN_BILL L,BRANCH B ,MERCHANT T " + " WHERE L.BRANCHID = B.ID AND L.MERCHANTID = T.MERCHANTID"; if (!Data.BILLID.IsEmpty()) { sql += (" and L.BILLID= " + Data.BILLID); } DataTable joinbill = DbHelper.ExecuteTable(sql); joinbill.NewEnumColumns <普通单据状态>("STATUS", "STATUSMC"); return(new Tuple <dynamic>(joinbill.ToOneLine())); }
public UIResult ShowOneJoinDetail(JOIN_BILLEntity Data) { return(new UIResult(service.JsglService.ShowOneJoinDetail(Data))); }
public UIResult GetJoinBillElement(JOIN_BILLEntity Data) { return(new UIResult(service.JsglService.GetJoinBillElement(Data))); }