public static Dictionary <string, DataTable> SetBusinessDataTable <T>(T t, string TableName, string objectName, string Upstream, out string DJBH) where T : class { var sql = string.Empty; DataTable tb = null; Dictionary <string, object> ListName = null; DJBH = string.Empty; switch (objectName) { #region //库存调整单 case "Regulation": //库存 { Regulation retail = t as Regulation; if (string.IsNullOrWhiteSpace(retail.DM2_1)) { retail.DM2_1 = InvoicesManage.GetCKKW(retail.DM2); //仓库库位 } if (string.IsNullOrEmpty(retail.BYZD12)) { retail.BYZD12 = "0.0000"; } if (string.IsNullOrEmpty(retail.QDDM)) { retail.QDDM = InvoicesManage.GetCANGKUValue("QDDM", retail.DM2); } if (string.IsNullOrWhiteSpace(retail.DJBH)) { retail.DJBH = InvoicesManage.GetNewDJBH(TableName, retail.QDDM, retail.DM2, retail.YDJH); } retail.BYZD1 = InvoicesManage.GetJGSD(InvoicesManage.GetCANGKUValue("JGSD", retail.DM2)).ToString(); retail.DM1 = "000"; retail.DJXZ = "0"; retail.YGDM = InvoicesManage.GetCANGKUValue("YGDM", retail.DM2); retail.BYZD5 = retail.BYZD1; retail.JZ = "0"; retail.RQ_4 = DateTime.Now; retail.SHRQ = retail.RQ.ToString(); retail.YSRQ = retail.RQ.ToString(); retail.YGDM = InvoicesManage.GetCANGKUValue("YGDM", retail.DM2); DJBH = retail.DJBH; ListName = RequestBuilder.getProperties <Regulation>(retail, objectName); break; } #endregion } tb = InvoicesManage.SetDataTable(ListName, TableName); if ("SG_Gathering".Equals(objectName)) { tb.PrimaryKey = new DataColumn[] { tb.Columns["vMBillID"] } } ; else { tb.PrimaryKey = new DataColumn[] { tb.Columns["DJBH"] } }; sql = InvoicesManage.SetSQLValue(ListName, TableName, "", objectName); Dictionary <string, DataTable> dic = new Dictionary <string, DataTable>(); dic.Add(sql, tb); return(dic); }
public static Dictionary <string, DataTable> SetEntryOrderDetail_QT_2(string DJBH, string TableName, DataRow dataRow, string KHDM) { int num = 0; Dictionary <string, DataTable> dictionary = new Dictionary <string, DataTable>(); List <Dictionary <string, object> > list = new List <Dictionary <string, object> >(); string text = string.Empty; Dictionary <string, DataTable> result = null; try { string sql = string.Format(@"SELECT TOP 1 TMDZB.SPDM,TMDZB.GG1DM,TMDZB.GG2DM FROM dbo.TMDZB WHERE SPDM='{0}' AND SPTM='{1}' ", dataRow["item_id"], dataRow["sku_id"]); DataTable dataTable = _testDbManager.FillData(sql); string sPDM = string.Empty; string gG1DM = string.Empty; string gG2DM = string.Empty; sPDM = dataTable.Rows[0]["SPDM"].ToString(); gG1DM = ((dataTable.Rows[0]["GG1DM"].ToString() == "") ? _testDbManager.ExecuteScalar("select top 1 GGDM from guige1").ToString() : dataTable.Rows[0]["GG1DM"].ToString()); gG2DM = ((dataTable.Rows[0]["GG2DM"].ToString() == "") ? _testDbManager.ExecuteScalar("select top 1 GGDM from guige2").ToString() : dataTable.Rows[0]["GG2DM"].ToString()); PurchaseDetail purchaseDetail = new PurchaseDetail(); purchaseDetail.DJBH = DJBH; purchaseDetail.SPDM = sPDM; purchaseDetail.GG1DM = gG1DM; purchaseDetail.GG2DM = gG2DM; purchaseDetail.SL = dataRow["current_amount"].ToString(); purchaseDetail.SL_2 = dataRow["current_amount"].ToString(); purchaseDetail.DJ = (Convert.ToDouble(dataRow["item_price"]) / 100).ToString(); purchaseDetail.CKJ = (Convert.ToDouble(dataRow["item_price"]) / 100).ToString(); purchaseDetail.ZK = "1.00"; purchaseDetail.JE = (Convert.ToDouble(dataRow["current_amount"].ToString()) * Convert.ToDouble(dataRow["item_price"])).ToString(); purchaseDetail.byzd8 = InvoicesManage.GetKEHUValue("BYZD8", KHDM); if (string.IsNullOrEmpty(purchaseDetail.byzd8)) { purchaseDetail.byzd8 = "0.00"; } purchaseDetail.byzd9 = (Convert.ToDouble(purchaseDetail.JE) * (1.0 - Convert.ToDouble(purchaseDetail.byzd8))).ToString(); purchaseDetail.BYZD12 = purchaseDetail.CKJ; num++; purchaseDetail.MIBH = num; purchaseDetail.MXBH = num; purchaseDetail.HH = "1"; purchaseDetail.byzd1 = "0"; purchaseDetail.DJ_1 = purchaseDetail.CKJ; Dictionary <string, object> item = DataTableBusiness.SetInvoicesBusiness <PurchaseDetail>(purchaseDetail, TableName, "PurchaseDetail", "", ""); if (string.IsNullOrEmpty(text)) { text = DataTableBusiness.SetInvoicesBusiness <PurchaseDetail>(purchaseDetail, TableName + "MX", "PurchaseDetail", DJBH); } list.Add(item); DataTable value = InvoicesManage.SetDataTable(list, TableName + "MX"); dictionary.Add(text, value); result = dictionary; } catch (Exception ex) { } return(result); }
/// <summary> /// 生成单据编号 /// </summary> /// <param name="_TableName"></param> /// <param name="YDJH"></param> /// <param name="_vFuncID"></param> /// <returns></returns> public static string GetNewDJBH(string _TableName, string QDDM, string KHDM, string YDJH) { var DJBH = string.Empty; DJBH = InvoicesManage.ProduceDJBH(QDDM, KHDM, _TableName); if (string.IsNullOrEmpty(DJBH)) { DJBH = YDJH; } return(DJBH); }
public static string SetInvoicesBusiness <T>(T t, string TableName, string objectName, string DJBH) where T : class { var sql = string.Empty; Dictionary <string, object> ListName = null; switch (objectName) { case "PurchaseDetail": { PurchaseDetail sggatherings = t as PurchaseDetail; ListName = RequestBuilder.getProperties <PurchaseDetail>(sggatherings, objectName); break; } } sql = InvoicesManage.SetSQLValue(ListName, TableName, DJBH, ""); return(sql); }