| | |
| | | DeleteRelation(ref sReturn, lngBillKey); |
| | | //å é¤å表 |
| | | DeleteBillSub(lngBillKey); |
| | | |
| | | //æå
¥å表 |
| | | omodel.HInterID = lngBillKey; |
| | | foreach (Model.ClsYS_ReceiveOtherBillSub oSub in DetailColl) |
| | | { |
| | | string subSql = "insert into YS_ReceiveOtherBillSub" + |
| | | "" + |
| | | "" + |
| | | "" + |
| | | "(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType" + |
| | | ",HProjectMoneyID,HTypeSub,HMoney,HTaxRate,HSumMoney) " + |
| | | " values(" + |
| | | "" + omodel.HInterID.ToString() + |
| | | "," + oSub.HEntryID.ToString() + |
| | | "," + oSub.HSourceInterID + |
| | | "," + oSub.HSourceEntryID + |
| | | ",'" + oSub.HSourceBillNo + |
| | | "','" + oSub.HSourceBillType + |
| | | "','" + oSub.HProjectMoneyID + |
| | | "','" + oSub.HTypeSub + |
| | | "','" + oSub.HMoney + |
| | | "','" + oSub.HTaxRate + |
| | | "','" + oSub.HSumMoney + |
| | | "')"; |
| | | oCn.RunProc(subSql); |
| | | } |
| | | sReturn = "ä¿®æ¹åæ®æåï¼"; |
| | | oCn.Commit(); |
| | | return true; |
| | |
| | | ",'" + omodel.HAccDate.ToShortDateString() + "'," + omodel.HCusID.ToString() + "," + omodel.HCurID.ToString() + "," + omodel.HExRate.ToString() + |
| | | ", '" + omodel.HDeptID.ToString() + "','" + omodel.HEmpID.ToString() + "','" + omodel.HProjectMoneyID.ToString() + "','" + omodel.HType+ "','"+ omodel.HMoney+ "','" + omodel.HTaxRate + "','" + omodel.HSumMoney + "','" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "','" + omodel.HOrgID + "'" + |
| | | ") "); |
| | | |
| | | //æå
¥å表 |
| | | foreach (Model.ClsYS_ReceiveOtherBillSub oSub in DetailColl) |
| | | { |
| | | string subSql = "insert into YS_ReceiveOtherBillSub" + |
| | | "" + |
| | | "" + |
| | | "" + |
| | | "(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType" + |
| | | ",HProjectMoneyID,HTypeSub,HMoney,HTaxRate,HSumMoney) " + |
| | | " values(" + |
| | | "" + omodel.HInterID.ToString() + |
| | | "," + oSub.HEntryID.ToString() + |
| | | "," + oSub.HSourceInterID + |
| | | "," + oSub.HSourceEntryID + |
| | | ",'" + oSub.HSourceBillNo + |
| | | "','" + oSub.HSourceBillType + |
| | | "','" + oSub.HProjectMoneyID + |
| | | "','" + oSub.HTypeSub + |
| | | "','" + oSub.HMoney + |
| | | "','" + oSub.HTaxRate + |
| | | "','" + oSub.HSumMoney + |
| | | "')"; |
| | | oCn.RunProc(subSql); |
| | | } |
| | | sReturn = "æ°å¢åæ®æåï¼"; |
| | | oCn.Commit(); |
| | | return true; |
| | |
| | | <Compile Include="å·¥èµç®¡ç\ClsPay_SubsidyChangeBillSub.cs" /> |
| | | <Compile Include="å·¥èµç®¡ç\ClsPay_SumBalBillMain .cs" /> |
| | | <Compile Include="å·¥èµç®¡ç\ClsPay_SumBalBillSub.cs" /> |
| | | <Compile Include="åºæ¶ç®¡ç\ClsYS_ReceiveOtherBillSub.cs" /> |
| | | <Compile Include="ææ¬ç®¡ç\ClsCB_ChangeMoneyBillMain.cs" /> |
| | | <Compile Include="ææ¬ç®¡ç\ClsCB_ChangeMoneyBillSub.cs" /> |
| | | <Compile Include="ææ¬ç®¡ç\ClsCB_EntrustMoneyCost_M.cs" /> |
| | |
| | | <Compile Include="åºæ¶ç®¡ç\ClsYS_ReceiveBillMain.cs" /> |
| | | <Compile Include="åºæ¶ç®¡ç\ClsYS_ReceiveBillSub.cs" /> |
| | | <Compile Include="åºæ¶ç®¡ç\ClsYS_ReceiveOtherBillMain.cs" /> |
| | | <Compile Include="åºæ¶ç®¡ç\ClsYS_ReceiveOtherBillSub.cs" /> |
| | | <Compile Include="åºæ¶ç®¡ç\ClsYS_ReceiveShouldBillMain.cs" /> |
| | | <Compile Include="åºæ¶ç®¡ç\ClsYS_ReceiveShouldBillSub.cs" /> |
| | | <Compile Include="计å管ç\ClsGy_ICBomBillMain.cs" /> |
| | |
| | | { |
| | | public DateTime HEntryCloseDate;// datetime --è¡å
³é (é»è®¤ä¸º'') new |
| | | public string HRemark;// varchar(200) --夿³¨ |
| | | public Int64 HProjectMoneyID;// int //è´¹ç¨é¡¹ç® |
| | | public string HTypeSub;// varchar(20) --å票类å |
| | | public double HMoney;// dec(18,8) //åæ®éé¢ |
| | | public double HTaxRate;// dec(18,8) //ç¨ç |
| | | public double HSumMoney;// dec(18,8) //æ»éé¢ |
| | | } |
| | | } |
| | |
| | | } |
| | | |
| | | |
| | | //å¾å°æå¤§åºç¡èµæçæµæ°´å· HNumber |
| | | public static string CreateHNumber(string BillCode,string HName,string TableName, ref string sReturn, bool Add) |
| | | { |
| | | |
| | | Int64 Glida; |
| | | Int32 CodeLen; |
| | | string sBillNumber = ""; |
| | | char c = Convert.ToChar("0"); |
| | | string sKjYear = DateTime.Today.Year.ToString(); |
| | | string sPeriod = DateTime.Today.Month.ToString(); |
| | | string sDay = DateTime.Today.Day.ToString(); |
| | | //å¾å°åæ®å·è¡¨ ä¿¡æ¯ |
| | | ClsSqlHelper oCn = new ClsSqlHelper(); |
| | | DataSet Ds = new DataSet(); |
| | | DataSet Dss = new DataSet(); |
| | | //ç¬¬ä¸æ¬¡æ¥è¯¢æ°æ®æ¯å¦åå¨ ä¸åå¨å°±æ·»å |
| | | Ds = oCn.RunProcReturn("Select * from Gy_MaxNumber where BillName='" + HName.Trim() + "'", "Gy_MaxNumber"); |
| | | //æå
¥æ°è®°å½ 表å,表åç§°,å½åid |
| | | if (Ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | |
| | | oCn.RunProc("insert into Gy_MaxNumber(BillType,BillName,IDNow) values('" + TableName.Trim() + "','" + HName.Trim() + "',1)"); |
| | | } |
| | | |
| | | //ç¬¬äºæ¬¡æ¥è¯¢ æ¯æ¥è¯¢æå
¥çæ°æ°æ® |
| | | Dss = oCn.RunProcReturn("Select * from Gy_MaxNumber where BillName='" + HName.Trim() + "'", "Gy_MaxNumber"); |
| | | if (Dss.Tables[0].Rows.Count != 0) |
| | | { |
| | | |
| | | Glida = ClsPub.isLong(Dss.Tables[0].Rows[0]["Glida"].ToString()); |
| | | CodeLen = ClsPub.isInt(Dss.Tables[0].Rows[0]["CodeLen"].ToString()); |
| | | } |
| | | else |
| | | { |
| | | return ""; |
| | | } |
| | | string sStr; |
| | | switch (Glida) |
| | | { |
| | | case 0://çº¯æµæ°´å· |
| | | Ds = oCn.RunProcReturn("Select * from Gy_MaxNumber where BillName='" + HName.Trim() + "'", "Gy_MaxNumber"); |
| | | if (Ds.Tables[0].Rows.Count != 0) |
| | | { |
| | | sStr = new string(c, CodeLen - (Ds.Tables[0].Rows[0]["IDNow"].ToString()).Length); |
| | | sBillNumber = BillCode.Trim() + sStr + Ds.Tables[0].Rows[0]["IDNow"].ToString().Trim(); |
| | | } |
| | | |
| | | if (Add == true) |
| | | { |
| | | oCn.RunProc("update Gy_MaxNumber set IDNow=IDNow+1 where BillName='" + HName.Trim() + "'"); |
| | | } |
| | | return sBillNumber; |
| | | |
| | | case 1://æ ¹æ® YYå¹´+MMæ æ¥ + æµæ°´å· çæåæ®å· ï¼æ¥ éç¨äº ä»åºçåæ®µï¼ |
| | | return sBillNumber; |
| | | case 2: //æ ¹æ®å¹´+æ+æ¥ çæåæ®å· |
| | | return sBillNumber; |
| | | case 3: //æ ¹æ® ä¹ä¸ ï¼S + å¹´ï¼23ï¼+äºä½æµæ°´å·ï¼å®ä¾ï¼S2300001 |
| | | return sBillNumber; |
| | | case 4: //æ ¹æ® ä¹ä¸ å·¥åºæµè½¬å¡å·æ¹æå¹´+æ+å使µæ°´å·ï¼23050001ï¼ |
| | | return sBillNumber; |
| | | default: |
| | | return sBillNumber; |
| | | |
| | | } |
| | | oCn.CnClose(); |
| | | oCn.CnDispose(); |
| | | oCn = null; |
| | | } |
| | | |
| | | //夿æ¯å¦å卿é,å¹¶åå
¥æ¥å¿ |
| | | public static bool Security_Log(string gnsy, int LogTF, bool Msg,string CurUserName) |
| | | { |
| | |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// èªå¨è·ååºç¡èµæ æµæ°´å· å°±æ¯ä»£ç |
| | | /// </summary> |
| | | /// <param name="HBillType"></param> |
| | | /// <returns></returns> |
| | | [Route("Web/GetMAXNumber")] |
| | | [HttpGet] |
| | | public object GetMAXNumber(string HBillType,string HName,string TableName) |
| | | { |
| | | try |
| | | { |
| | | string HNumber = ""; |
| | | HNumber = DBUtility.ClsPub.CreateHNumber(HBillType,HName, TableName, ref DBUtility.ClsPub.sExeReturnInfo, true); |
| | | //----------å建è表------------------------ |
| | | DataTable dt_Main = new DataTable("Json"); |
| | | dt_Main.Columns.Add("HNumber", typeof(string)); |
| | | |
| | | //---------å建æ°è¡------------------------ |
| | | DataRow dr_main = dt_Main.NewRow();//å建æ°è¡ |
| | | dt_Main.Rows.Add(dr_main);//å°æ°è¡å å
¥å°è¡¨ä¸ |
| | | dr_main["HNumber"] = DBUtility.ClsPub.isStrNull(HNumber); |
| | | |
| | | |
| | | if (HNumber == null) |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "è·å失败"; |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | else |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 1; |
| | | objjson.Message = "è·åæå"; |
| | | objjson.data = dt_Main; |
| | | return objjson; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "è·å失败" + e.ToString(); |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | } |
| | | |
| | | |
| | | //[Route("Web/Get_MaxBillNoAndID")] |
| | | //[HttpGet] |
| | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | DataSet ds; |
| | | |
| | | public class ClsYS_ReceiveOtherBillSubs |
| | | { |
| | | |
| | | public Int64 HProjectMoneyIDSub;// int //è´¹ç¨é¡¹ç® |
| | | public string HTypeSub;// varchar(20) --å票类å |
| | | public double HMoneySub;// dec(18,8) //åæ®éé¢ |
| | | public double HTaxRateSub;// dec(18,8) //ç¨ç |
| | | public double HSumMoneySub;// dec(18,8) //æ»éé¢ |
| | | } |
| | | |
| | | |
| | | #region å
¶ä»åºæ¶åå表 æ¥è¯¢ |
| | | /// <summary> |
| | | /// è¿å项ç®é¶æ®µå表 |
| | |
| | | var _value = msg["msg"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | | string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg2 = sArray[0].ToString(); //è¡¨å¤´æ°æ® |
| | | string refSav = sArray[1].ToString(); //æä½æ¹å¼ |
| | | string msg4 = sArray[2].ToString(); //ç¨æ· |
| | | string msg2 = sArray[0].ToString(); |
| | | string msg3 = sArray[1].ToString(); //å表 |
| | | string refSav = sArray[2].ToString();//æä½æ¹å¼æ°æ®ç±»å 1æ·»å 3ä¿®æ¹ 2 å¤å¶ |
| | | string msg4 = sArray[3].ToString();//ç¨æ·å |
| | | |
| | | DBUtility.ClsPub.CurUserName = msg4; |
| | | |
| | |
| | | } |
| | | oBill.omodel = oItem; |
| | | } |
| | | // è¡¨ä½æ°æ® |
| | | //æ },{æ¥æåæ°ç» //廿ãåã |
| | | msg3 = msg3.Substring(1, msg3.Length - 2); |
| | | msg3 = msg3.Replace("\\", ""); |
| | | msg3 = msg3.Replace("\n", ""); //\n |
| | | List<Model.ClsYS_ReceiveOtherBillSub> ls = new List<Model.ClsYS_ReceiveOtherBillSub>(); |
| | | ls = oListModels.getObjectByJson_YS_ReceiveOtherBillSub(msg3); |
| | | int i = 0; |
| | | foreach (Model.ClsYS_ReceiveOtherBillSub oItemSub in ls) |
| | | { |
| | | i++; |
| | | oItemSub.HEntryID = i; |
| | | |
| | | |
| | | oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); |
| | | oItemSub.HCloseType = false; //å
³éç±»å |
| | | |
| | | oBill.DetailColl.Add(oItemSub); |
| | | |
| | | } |
| | | |
| | | //ä¿å |
| | | //ä¿å宿¯åå¤ç |
| | |
| | | { |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_YS_ReceiveOtherBillMainList where hmainid=" + HInterID, "h_v_YS_ReceiveOtherBillMainList"); |
| | | List<DataTable> tableList = new List<DataTable>(); |
| | | |
| | | ds = oCN.RunProcReturn("exec h_p_YS_ReceiveOtherBillMain_Edit " + HInterID, "h_p_YS_ReceiveOtherBillMain_Edit"); |
| | | tableList.Add(ds.Tables[0]); |
| | | tableList.Add(ds.Tables[1]); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | objJsonResult.data = tableList; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | |
| | | ",HQty,HBadQty,HWasterQty,HBarCode,HAddr,HMaker,HMakeDate" + |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSplitNO,HSourceBillType" + |
| | | ",HRelationInterID,HRelationEntryID,HRelationBillNo,HReportEntryID,HBillStatus" + |
| | | ") " + |
| | | ",HICMOReportInterID) " + |
| | | " values(" + omodel.HInterID.ToString() + ",'" + BillType + "'," + omodel.HSourceID.ToString() + "," + omodel.HReportType.ToString() + "," + omodel.HPieceQty.ToString() + |
| | | "," + omodel.HMaterID.ToString() + ",'" + omodel.HGroupID + "','" + omodel.HWorkManID + "','" + omodel.HWorkReportDate + "','" + omodel.HDate + "'" + |
| | | ",'" + omodel.HBillSubType.ToString() + "','" + omodel.HBillNo + "','" + omodel.HICMOInterID + "','" + omodel.HICMOEntryID + "','" + omodel.HICMOBillNo + "'" + |
| | | "," + omodel.HQty.ToString() + "," + omodel.HBadQty.ToString() + "," + omodel.HWasterQty.ToString() + ",'" + omodel.HBarCode + "','" + omodel.HAddr + "','" + omodel.HMaker+ "','" + omodel.HMakeDate + "'" + |
| | | "," + omodel.HSourceInterID.ToString() + "," + omodel.HSourceEntryID.ToString() + ",'" + omodel.HSourceBillNo + "','" + omodel.HSplitNO + "','" + omodel.HSourceBillType + "'" + |
| | | "," + omodel.HRelationInterID.ToString() + "," + omodel.HRelationEntryID.ToString() + ",'" + omodel.HRelationBillNo + "'," + omodel.HReportEntryID.ToString() + "," + omodel.HBillStatus.ToString() + |
| | | ") "); |
| | | ",'"+ omodel.HSourceInterID.ToString() + "') "); |
| | | double sumqty = omodel.HQty + omodel.HBadQty + omodel.HWasterQty; //æ±æ¥æ°é+ä¸è¯+æ¥åº |
| | | //ååçäº§ç¶æä¸´æ¶è¡¨Sc_ICMOBillStatus_Tmpæåæ±æ¥æ°é HSplitRelationQty |
| | | oCn.RunProc("update Sc_ICMOBillStatus_Tmp set HSplitRelationQty=HSplitRelationQty+" + sumqty + " where HICMOBillNo='" + omodel.HICMOBillNo + "' and HSourceID='" + omodel.HSourceID + "' and HICMOInterID='" + omodel.HICMOInterID + "' and HICMOEntryID='" + omodel.HICMOEntryID + "' and HInterID="+ omodel.HSourceInterID.ToString()); |
| | |
| | | //ååäº§éæ±æ¥åï¼è´¨éæ±æ¥åå
³èåæ®µ,ç产订åå
³èæ°é |
| | | ds = oCn.RunProcReturn("exec h_p_Sc_ICMOReportBill_ReverseWriteQty " + omodel.HInterID + "," + oSub.HEntryID + ",'" + omodel.HBillNo + "'," + |
| | | DetailColl[0].HICMOInterID + "," + DetailColl[0].HICMOEntryID + ",'" + DetailColl[0].HICMOBillNo + "','" + DetailColl[0].HSourceID + "','" + |
| | | "Add" + "'," + 0 |
| | | "Add" + "'," + 0+","+ DetailColl[0].HICMOTempID |
| | | , "h_p_Sc_ICMOReportBill_ReverseWriteQty"); |
| | | if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) == "1") |
| | | { |
| | |
| | | } |
| | | else |
| | | { |
| | | oSystemParameter.ShowBill(ref sReturn); |
| | | JObject model = new JObject(); |
| | | model.Add("FBillType", new JObject() { ["FNumber"] = Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FBillType"]) }); //åæ®ç±»å |
| | | model.Add("FDate", Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FDate"])); //åæ®æ¥æ |
| | |
| | | // |
| | | if (oSystemParameter.omodel.WMS_CampanyName == "ä¹è±") //ç³»ç»åæ° å®¢æ·å®å¶ååç§° 空ç½ä¸ºéç¨ |
| | | { |
| | | |
| | | FentityModel.Add("FShiftGroupId", new JObject() { ["FNumber"] = item["FShiftGroupId"].ToString() });//çç» |
| | | FentityModel.Add("F_UUBK_CZG1", new JObject() { ["FSTAFFNUMBER"] = item["F_UUBK_CZG1"].ToString() });// æä½å |
| | | } |
| | | FentityModel.Add("FShiftGroupId", new JObject() { ["FNumber"] = item["FShiftGroupId"].ToString() });//çç» |
| | | FentityModel.Add("F_UUBK_CZG1", new JObject() { ["FSTAFFNUMBER"] = item["F_UUBK_CZG1"].ToString() });// æä½å |
| | | |
| | | |
| | | FentityModel.Add("FBOMID", new JObject() { ["FNumber"] = item["FBOMID"].ToString() });// BOMçæ¬ |
| | | |
| | |
| | | //æäº¤å®¡æ ¸ |
| | | string result1 = string.Empty; |
| | | string result2 = string.Empty; |
| | | var fID = JObject.Parse(result)["Result"]["Id"].ToString(); |
| | | var fBillNo = JObject.Parse(result)["Result"]["Number"].ToString(); |
| | | var json = new |
| | | { |
| | | Ids = fID, |
| | | }; |
| | | if (oSystemParameter.omodel.Sc_ICMOReportBill_AutoCheck == "Y") //ç³»ç»åæ° èªå¨å®¡æ ¸ |
| | | { |
| | | result1 = InvokeHelper.Submit("PRD_MORPT", JsonConvert.SerializeObject(jsonRoot));//æäº¤ |
| | | result2 = InvokeHelper.Audit("PRD_MORPT", JsonConvert.SerializeObject(jsonRoot));//å®¡æ ¸ |
| | | result1 = InvokeHelper.Submit("PRD_MORPT", JsonConvert.SerializeObject(json));//æäº¤ |
| | | result2 = InvokeHelper.Audit("PRD_MORPT", JsonConvert.SerializeObject(json));//å®¡æ ¸ |
| | | |
| | | if (JObject.Parse(result1)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE") |
| | | { |
| | | sReturn = "çäº§æ±æ¥ååå·:" + HBillNo + ",æäº¤å¤±è´¥" + result; |
| | | sReturn = "çäº§æ±æ¥ååå·:" + HBillNo + ",æäº¤å¤±è´¥" + result1; |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | |
| | | if (JObject.Parse(result2)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE") |
| | | { |
| | | sReturn = "çäº§æ±æ¥ååå·:" + HBillNo + ",å®¡æ ¸å¤±è´¥" + result2; |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | } |
| | | } |
| | | } |
| | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// å¤çæ°å¢å
¶ä»åºæ¶åå表çjson |
| | | /// </summary> |
| | | /// <param name="jsonString"></param> |
| | | /// <returns></returns> |
| | | public List<Model.ClsYS_ReceiveOtherBillSub> getObjectByJson_YS_ReceiveOtherBillSub(string jsonString) |
| | | { |
| | | jsonString = "[" + jsonString.ToString() + "]"; |
| | | List<Model.ClsYS_ReceiveOtherBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsYS_ReceiveOtherBillSub>>(jsonString); |
| | | return list; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// å¤çæ°å¢å
¶ä»åºä»å表çjson |
| | | /// </summary> |
| | | /// <param name="jsonString"></param> |
| | |
| | | public Int64 HPlanMode; |
| | | public Int64 HERPInterID; |
| | | public Int64 HERPEntryID; |
| | | public Int64 HICMOTempID; |
| | | } |
| | | } |