完善修复基础资料列表增删改查功能(物料,仓库,职员,部门,组织,计量单位)
| | |
| | | public static void Sub_CheckUseStatus(DataGridView grd, int IDCol,string sProcName) |
| | | { |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | Int64 sItemID; |
| | | Int64 sItemID; |
| | | try |
| | | { |
| | | //循ç¯å½åç½æ ¼éä¸é¡¹ç® |
| | |
| | | b14f4fcc24537f5a4b1d1021595a00930f37f5f5 |
| | | 2b98949b87d39f3f48ff12a0b7c639d4a4168873 |
| | |
| | | D:\Gitä»åº\MESWMS-API(ææ°)\MES-WEB-API\MES-WEB-API\PayM\obj\x86\Debug\PayM.csproj.CopyComplete |
| | | D:\Gitä»åº\MESWMS-API(ææ°)\MES-WEB-API\MES-WEB-API\PayM\obj\x86\Debug\PayM.dll |
| | | D:\Gitä»åº\MESWMS-API(ææ°)\MES-WEB-API\MES-WEB-API\PayM\obj\x86\Debug\PayM.pdb |
| | | D:\æºäºLMes\MES-WEB-API\PayM\bin\x86\Debug\PayM.dll |
| | | D:\æºäºLMes\MES-WEB-API\PayM\bin\x86\Debug\PayM.pdb |
| | | D:\æºäºLMes\MES-WEB-API\PayM\bin\x86\Debug\BLL.dll |
| | | D:\æºäºLMes\MES-WEB-API\PayM\bin\x86\Debug\DAL.dll |
| | | D:\æºäºLMes\MES-WEB-API\PayM\bin\x86\Debug\DBUtility.dll |
| | | D:\æºäºLMes\MES-WEB-API\PayM\bin\x86\Debug\Model.dll |
| | | D:\æºäºLMes\MES-WEB-API\PayM\bin\x86\Debug\Pub_Class.dll |
| | | D:\æºäºLMes\MES-WEB-API\PayM\bin\x86\Debug\Pub_Control.dll |
| | | D:\æºäºLMes\MES-WEB-API\PayM\bin\x86\Debug\SQLHelper.dll |
| | | D:\æºäºLMes\MES-WEB-API\PayM\bin\x86\Debug\Kingdee.BOS.WebApi.Client.dll |
| | | D:\æºäºLMes\MES-WEB-API\PayM\bin\x86\Debug\Newtonsoft.Json.dll |
| | | D:\æºäºLMes\MES-WEB-API\PayM\bin\x86\Debug\BLL.pdb |
| | | D:\æºäºLMes\MES-WEB-API\PayM\bin\x86\Debug\DAL.pdb |
| | | D:\æºäºLMes\MES-WEB-API\PayM\bin\x86\Debug\DBUtility.pdb |
| | | D:\æºäºLMes\MES-WEB-API\PayM\bin\x86\Debug\Model.pdb |
| | | D:\æºäºLMes\MES-WEB-API\PayM\bin\x86\Debug\Pub_Class.pdb |
| | | D:\æºäºLMes\MES-WEB-API\PayM\bin\x86\Debug\Pub_Control.pdb |
| | | D:\æºäºLMes\MES-WEB-API\PayM\bin\x86\Debug\SQLHelper.pdb |
| | | D:\æºäºLMes\MES-WEB-API\PayM\bin\x86\Debug\Interop.gregn6Lib.dll |
| | | D:\æºäºLMes\MES-WEB-API\PayM\bin\x86\Debug\AxInterop.gregn6Lib.dll |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.csprojAssemblyReference.cache |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\Interop.gregn6Lib.dll |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\AxInterop.gregn6Lib.dll |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.csproj.ResolveComReference.cache |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Form2.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.HR_ContractBookBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.HR_ContractBookBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.HR_EmpChangeBillQuery.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.HR_EmpUpChangeBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.HR_EmpUpChangeBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.HR_FamilyMemberBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.HR_FamilyMemberBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.HR_InsuranceBookBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.HR_InsuranceBookBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.HR_LearnHistoryBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.HR_LearnHistoryBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.HR_PaperPhotoBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.HR_PaperPhotoBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.HR_RewardsPunishBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.HR_RewardsPunishBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.HR_WorkInjuryBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.HR_WorkInjuryBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.HR_WorkSkillBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.HR_WorkSkillBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.HR_WorkStoryBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.HR_WorkStoryBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.HR_EmpFosterBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.HR_EmpFosterBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.FrmChangeDate.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_AbsentBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_AbsentBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_DuSubsidyItemBillQuery.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_DuSubsidyItemBill_KS.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_EarlyLateErrBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_EarlyLateErrBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_EmpInitChangeBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_EmpInitChangeBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_ErrWorkTimesSendBillQuery.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_GroupBalBillQuery.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_MonthICMOStockSumBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_MonthICMOStockSumBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_OtherBalBillQuery.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_OutApplyBillQuery.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_OverApplyBillQuery.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\HuanXin.ERP.Pay_PayMentBillListDlg.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\HuanXin.ERP.Pay_PayMentBillListUnPayDlg.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_PayMentBillQuery.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_PayMent_QC.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_PayMent_QCAdd.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_ProcPriceRequestBillQuery.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_RewardPunishBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_RewardPunishBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_SingleBalBillList_KS.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_SingleBalBillQuery.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_SingleBalBill_Enter.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_SingleBalBill_KS.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_SingleBalBill_YR.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_SumBalBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_SumBalBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_SumBalBill_JS.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_WorkErrTimesBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_WorkErrTimesBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_WorkTimesBillQuery.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_WorkTimesSumQueryBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_WorkTimesSumQueryBillListDlg.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_OutForComApplyBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_OutForComApplyBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_PayMentBillReport.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_PayMentBillReportDlg.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_SingleBalBillEntryReport.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_SingleBalBillEntryReportDlg.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_SingleBalBillSumReport.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_SingleBalBillSumReportDlg.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_WorkTimesPayMentEntryReport.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_WorkTimesPayMentEntryReportDlg.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_WorkTimesPayMentSumReport.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_WorkTimesPayMentSumReportDlg.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_MonthSubsidyYearReport.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_YearToCashBillReport.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_YearToCashBillReportDlg.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Properties.Resources.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.HR_EmpDimissionBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.HR_EmpDimissionBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\OAM.HR_EmpEngageRequestBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\OAM.HR_EmpEngageRequestBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_CarOutApplyBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_CarOutApplyBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\CostM.Pay_PayMentBillAutoAddnew.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\CostM.Pay_PayMentBillAutoAddnew1.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\CostM.Pay_PayMentBillAutoAddnew2.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\CostM.Pay_PayMentBillAutoAddnew3.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\CostM.Pay_PayMentBillAutoAddnew4.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\CostM.Pay_PayMentBillAutoAddnew5.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\BaseSet.Gy_DataInTmp_DuSubsidyItem.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_DuSubsidyItemBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_DuSubsidyItemBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_ErrWorkTimesRequestBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_ErrWorkTimesRequestBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_ErrWorkTimesSendBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_ErrWorkTimesSendBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_GetNeedCheckErrWorkTimesSendBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_OtherMoney_Dlg.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_PayMentBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.HR_EmpChangeBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.HR_EmpChangeBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_GroupBalBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_GroupBalBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_PayMentDayBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_PayMentDayBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_ProcPriceRequestBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_ProcPriceRequestBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_OtherBalBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_OtherBalBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_OutApplyBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_OutApplyBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_OverApplyBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_OverApplyBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_SingleBalBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_SingleBalBillDlg.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_SingleBalBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_SubsidyChangeBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_SubsidyChangeBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_WorkTimesBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_WorkTimesBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_PayMentBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_EmpPayMentSumReport.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_EmpPayMentSumReportDlg.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_EmpWorkQtyEntryReport.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_EmpWorkQtyEntryReportDlg.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_InnerScrap.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_InnerScrapDlg.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_OuterScrap.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_OuterScrapDlg.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_PayMentDeptSendList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_PayMentDeptSendListDlg.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_PayMentDeptYearReport.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_PayMentDeptYearReportDlg.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_PayMentPrintReport.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_PayMentPrintReportDlg.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_PayMentSendList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_PayMentSendListDlg.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_PayMentYearReport.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_PayMentYearReportDlg.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_ProdWorkQtyEntryReport.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_ProdWorkQtyEntryReportDlg.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_ProdWorkQtySumReport.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_ProdWorkQtySumReportDlg.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_WorkTimesList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_WorkTimesListDlg.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_MonthWriteBillReportMX.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_MonthWriteBillReportMX2.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Err_MonthExpenseEntryBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Err_MonthExpenseEntryBillDlg.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.KQ_sourceReport.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.KQ_sourceReportDlg.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_MonthSubsidyEntryBillAdd.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_MonthSubsidyEntryBillReportMX.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_NoWorkTimesReport.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_NoWorkTimesReportDlg.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\CostM.Pay_AccPayMentDayBill.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\CostM.Pay_AccPayMentDayBill2.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\CostM.Pay_AccPayMentDayBill3.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\CostM.Pay_AccPayMentDayBill4.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\CostM.Pay_AccPayMentDayBill5.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\CostM.Pay_AccPayMentDayBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_MonthExpenseEntryBill1.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_MonthExpenseEntryBill2.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_MonthExpenseEntryBill3.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_MonthExpenseEntryBill4.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_MonthExpenseEntryBill5.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_MonthExpenseEntryBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_MonthExpenseEntryBillReport.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_MonthExpenseEntryBillReportDlg.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_MonthSubsidyEntryBillReport.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_MonthSubsidyEntryBillReportDlg.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_MonthWriteBillReport.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_MonthWriteBillReportDlg.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_WorkTimesCardBill1.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_WorkTimesCardBill2.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_WorkTimesCardBill3.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_WorkTimesCardBill4.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_WorkTimesCardBill5.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.Pay_WorkTimesCardBillList.resources |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.csproj.GenerateResource.cache |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.csproj.CoreCompileInputs.cache |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.csproj.CopyComplete |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.dll |
| | | D:\æºäºLMes\MES-WEB-API\PayM\obj\x86\Debug\PayM.pdb |
| | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCN.RollBack(); |
| | | //oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.Message; |
| | |
| | | long HCTPrjID = list[0].HCTPrjID; |
| | | long HProcID = list[0].HProcID; |
| | | string HBasePay = list[0].HBasePay; |
| | | DateTime HInComDate = list[0].HInComDate; |
| | | DateTime HDimissionDate = list[0].HDimissionDate; |
| | | DateTime HInComDate = list[0].HInComDate; //è¿åæ¥æ |
| | | DateTime HDimissionDate = list[0].HDimissionDate; //ç¦»èæ¥æ (å
许NULL) |
| | | bool HOverType = list[0].HOverType; |
| | | string HEmpType = list[0].HEmpType; |
| | | string HOtherDeduct3 = list[0].HOtherDeduct3; |
| | |
| | | string HMedicare = list[0].HMedicare; |
| | | bool HNoBrushFlag = list[0].HNoBrushFlag; |
| | | bool HShiftFlag = list[0].HShiftFlag; |
| | | DateTime HContactDate = list[0].HContactDate; |
| | | //DateTime HContactDate = list[0].HContactDate; //å忥æ |
| | | bool HStopwagesFlag = list[0].HStopwagesFlag; |
| | | string HDimissionReason = list[0].HDimissionReason; |
| | | long HDormID = list[0].HDormID; |
| | | string HArchivesNo = list[0].HArchivesNo; |
| | | DateTime HStayCardEDate = list[0].HStayCardEDate; |
| | | DateTime HCheckCardEDate = Convert.ToDateTime("1900/1/1"); |
| | | DateTime HStayCardEDate = list[0].HStayCardEDate; //æä½è¯å°ææ¥ |
| | | DateTime HCheckCardEDate = Convert.ToDateTime("1900/1/1"); //审æ£è¯å°ææ¥ |
| | | string HJobCardNo = list[0].HJobCardNo ?? ""; |
| | | DateTime HJobCardEDate = Convert.ToDateTime("1900/1/1"); |
| | | DateTime HJobCardEDate = Convert.ToDateTime("1900/1/1"); //å°±ä¸è¯å°ææ¥ |
| | | string HWorkType = list[0].HWorkType; |
| | | long HContractYear = list[0].HContractYear; |
| | | DateTime HContractBDate = list[0].HContractBDate; |
| | | DateTime HContractEDate = list[0].HContractEDate; |
| | | DateTime HContractBDate = list[0].HContractBDate; //ååå¼å§æ¥ |
| | | DateTime HContractEDate = list[0].HContractEDate; //ååå°ææ¥ |
| | | string HInsuranceNo = list[0].HInsuranceNo; |
| | | DateTime HInsuranceDate = list[0].HInsuranceDate; |
| | | DateTime HInsuranceDate = list[0].HInsuranceDate; //åä¿æ¥æ |
| | | bool HInsuranceStatus = list[0].HInsuranceStatus; |
| | | DateTime HSignDate = list[0].HSignDate; |
| | | DateTime HSignDate = Convert.ToDateTime("1900/1/1"); //ç¾çº¦æ¥æ |
| | | bool HSignStatus = list[0].HSignStatus; |
| | | string HOldCompany = list[0].HOldCompany ?? ""; |
| | | string HMarr = list[0].HMarr ?? ""; |
| | |
| | | string HSpec = list[0].HSpec ?? ""; |
| | | string HCompLev = list[0].HCompLev ?? ""; |
| | | string HEngLev = list[0].HEngLev ?? ""; |
| | | DateTime HGradDate = list[0].HGradDate; |
| | | DateTime HGradDate = list[0].HGradDate; //æ¯ä¸æ¥æ |
| | | string HGradSchool = list[0].HGradSchool ?? ""; |
| | | string HSalaryLev = list[0].HSalaryLev ?? ""; |
| | | long HDutyID = list[0].HDutyID; |
| | |
| | | string HStdDayPay = list[0].HStdDayPay ?? ""; |
| | | string HMinDayPay = list[0].HMinDayPay ?? ""; |
| | | string HMinMonthPay = list[0].HMinMonthPay ?? ""; |
| | | DateTime HMadeDate = list[0].HMadeDate; |
| | | //DateTime HMadeDate = list[0].HMadeDate; //å»ºç«æ¥æ |
| | | string HEmpRate = list[0].HEmpRate ?? ""; |
| | | string HExamRate = list[0].HExamRate ?? ""; |
| | | DateTime HHealthCardEDate = Convert.ToDateTime("1900/1/1"); |
| | | DateTime HHealthCardEDate = Convert.ToDateTime("1900/1/1"); //å¥åº·è¯å°ææ¥ |
| | | long HUSEORGID = list[0].HUSEORGID; |
| | | |
| | | ////夿æé |
| | | //if (!ClsPub.Security_Log(msg5, 1, false, msg4)) |
| | | //{ |
| | |
| | | ",HEmpType,HPayType,HOverType,HNoBrushFlag,HShiftFlag,HStopwagesFlag" + |
| | | ",HPostalCode,HBank,HBasePay,HExamLevPostMoney,HBSTDeptID" + |
| | | ",HOtherDeduct3,HInsurance,HMedicare,HDrydock" + |
| | | ",HBankAccount,HGroupID,HDeptID,HWorkTypeID,HCTPrjID,HAddress" + |
| | | ",HBankAccount,HGroupID,HDeptID,HWorkTypeID,HCTPrjID,HUSEORGID,HAddress" + |
| | | ") " + |
| | | " Values('" + HNumber + "','" + HName + "','" + HShortNumber + "'," + HEmpRate.ToString() + "," + HExamRate.ToString() + |
| | | "," + HLevel + "," + HParentID + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + HHighestPay.ToString() + "," + HOverPayRate.ToString() + |
| | | "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "'" + ",'" + HHelpCode + "'," + HInsuranceSubsidy.ToString() + "" + |
| | | ",'" + HBirthDay + "','" + HGradDate + "','" + HInsuranceDate + "','" + HContractBDate + "','" + HContractEDate + "'" + |
| | | " Values('" + HNumber + "','" + HName + "','" + HShortNumber + "','" + HEmpRate.ToString() + "','" + HExamRate.ToString() + |
| | | "','" + HLevel + "','" + HParentID + "','" + Convert.ToString(HEndFlag ? 1 : 0) + "','" + HHighestPay.ToString() + "','" + HOverPayRate.ToString() + |
| | | "','" + Convert.ToString(HStopflag ? 1 : 0) + "','" + HRemark + "'" + ",'" + HHelpCode + "','" + HInsuranceSubsidy.ToString() + |
| | | "','" + HBirthDay + "','" + HGradDate + "','" + HInsuranceDate + "','" + HContractBDate + "','" + HContractEDate + "'" + |
| | | ",'" + HJobCardEDate + "','" + HCheckCardEDate + "','" + HStayCardEDate + "','" + HHealthCardEDate + "'" + |
| | | "," + HAge.ToString() + ",'" + HSalaryLev + "'," + HContractYear.ToString() + "," + Convert.ToString(HInsuranceStatus ? 1 : 0) + "," + Convert.ToString(HSignStatus ? 1 : 0) + |
| | | ",'" + HSex + "','" + HMarr + "','" + HBlighty + "','" + HNation + "','" + HBlightyType + "'" + |
| | | ",'" + HAge.ToString() + "','" + HSalaryLev + "','" + HContractYear.ToString() + "','" + Convert.ToString(HInsuranceStatus ? 1 : 0) + "','" + Convert.ToString(HSignStatus ? 1 : 0) + |
| | | "','" + HSex + "','" + HMarr + "','" + HBlighty + "','" + HNation + "','" + HBlightyType + "'" + |
| | | ",'" + HGovStatus + "','" + HBloodType + "','" + HStature + "','" + HAvoird + "','" + HKnowLev + "'" + |
| | | ",'" + HProTitleID + "','" + HGradSchool + "','" + HEngLev + "','" + HCompLev + "','" + HSpec + "'" + |
| | | ",'" + HEmail + "','" + HNowAdd + "','" + HHomeAdd + "','" + HIDCard + "','" + HLinkPhone + "','" + HMobilePhone + "','" + HFax + "'" + |
| | | ",'" + HOldCompany + "','" + HInsuranceNo + "','" + HJobCardNo + "','" + HArchivesNo + "','" + HWorkType + "','" + HDimissionReason + "'" + |
| | | ",'" + HDimissionDate + "','" + HInComDate + "','" + HSignDate + "','" + HRelDate + "'" + |
| | | "," + HPostID.ToString() + "," + HDormID.ToString() + "," + HDutyID.ToString() + "," + HLeftMoneyRate.ToString() + |
| | | ",'" + HEmpType + "'" + ",'" + HPayType + "'" + "," + DBUtility.ClsPub.BoolToString(HOverType) + "" + "," + DBUtility.ClsPub.BoolToString(HNoBrushFlag) + "" + "," + DBUtility.ClsPub.BoolToString(HShiftFlag) + "" + "," + DBUtility.ClsPub.BoolToString(HStopwagesFlag) + "" + |
| | | ",'" + HPostalCode + "','" + HBank + "'," + HBasePay.ToString() + "," + HExamLevPostMoney.ToString() + ",'" + HBSTDeptID + "'" + |
| | | "," + HOtherDeduct3.ToString() + "" + "," + HInsurance.ToString() + "" + "," + HMedicare.ToString() + "" + "," + HDrydock.ToString() + "" + |
| | | ",'" + HBankAccount + "'" + "," + HGroupID.ToString() + "" + "," + HDeptID.ToString() + "," + HWorkTypeID.ToString() + "," + HCTPrjID.ToString() + ",'" + HAddress + "'" + "')", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | ",'" + HPostID.ToString() + "','" + HDormID.ToString() + "','" + HDutyID.ToString() + "','" + HLeftMoneyRate.ToString() + |
| | | "','" + HEmpType + "'" + ",'" + HPayType + "'" + ",'" + DBUtility.ClsPub.BoolToString(HOverType) + "','" + DBUtility.ClsPub.BoolToString(HNoBrushFlag) + "','" + DBUtility.ClsPub.BoolToString(HShiftFlag) + "','" + DBUtility.ClsPub.BoolToString(HStopwagesFlag) + |
| | | "','" + HPostalCode + "','" + HBank + "','" + HBasePay.ToString() + "','" + HExamLevPostMoney.ToString() + "','" + HBSTDeptID + "'" + |
| | | ",'" + HOtherDeduct3.ToString() + "','" + HInsurance.ToString() + "','" + HMedicare.ToString() + "','" + HDrydock.ToString() + |
| | | "','" + HBankAccount + "'" + ",'" + HGroupID.ToString() + "','" + HDeptID.ToString() + "','" + HWorkTypeID.ToString() + "','" + HCTPrjID.ToString() + "','" + HUSEORGID + "','" + HAddress + "')", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç |
| | | oCN.RunProc("Update Gy_Employee set HStopflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCN.Commit(); |
| | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCN.RollBack(); |
| | | //oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.Message; |
| | |
| | | return objJsonResult; |
| | | } |
| | | |
| | | oCN.RunProc("update Gy_Employee set HStopflag=1 where HItemID=" + HItemID); |
| | | oCN.RunProc("delete from Gy_Employee where HItemID=" + HItemID); |
| | | oCN.Commit();//æäº¤äºå¡ |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | |
| | | using System.Data; |
| | | using System.Data.SqlClient; |
| | | using System.Web.Http; |
| | | using System.Windows.Forms; |
| | | using WebAPI.Models; |
| | | using WebAPI.Service; |
| | | |
| | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | DataSet ds; |
| | | |
| | | |
| | | |
| | | ////æ£æµ å½åéä¸è¡ç 项ç®ç¶æ |
| | | //[Route("Gy_Material/CheckUseStatus")] |
| | | //[HttpGet] |
| | | //public void Sub_CheckUseStatus(int grd, int IDCol, string sProcName) |
| | | //{ |
| | | // SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | // Int64 sItemID; |
| | | // try |
| | | // { |
| | | // //循ç¯å½åç½æ ¼éä¸é¡¹ç® |
| | | // for (int i = 0; i < grd.SelectedRows.Count; i++) |
| | | // { |
| | | // //å¾å°å
ç |
| | | // sItemID = DBUtility.ClsPub.isLong(grd.Rows[grd.SelectedRows[i].Index].Cells[IDCol].Value); |
| | | // //è°ç¨å¨åè¿ç¨ h_p_Gy_CheckUseDept |
| | | // oCn.RunProc("exec " + sProcName + " " + sItemID.ToString(), ref ClsPub.sExeReturnInfo); |
| | | // } |
| | | // } |
| | | // catch (Exception e) |
| | | // { |
| | | // MessageBox.Show("æ£æµé误ï¼åå ï¼" + ClsPub.sExeReturnInfo); |
| | | // //objJsonResult.code = "0"; |
| | | // //objJsonResult.count = 0; |
| | | // //objJsonResult.Message = "æ£æµé误ï¼åå ï¼" + ClsPub.sExeReturnInfo; |
| | | // //objJsonResult.data = null; |
| | | // //return objJsonResult; |
| | | // } |
| | | //} |
| | | |
| | | /// <summary> |
| | | /// è¿åç©æå表 |
| | |
| | | string[] sArray = msg3.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg1 = sArray[0].ToString(); |
| | | string msg2 = sArray[1].ToString(); |
| | | string msg_HUSEORGID = sArray[2].ToString(); |
| | | Int64 HItemID = 0; |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | |
| | |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | oItem.HUSEORGID = Convert.ToInt32(msg_HUSEORGID); //ç»ç»id |
| | | oItem.HShortNumber = sShortNumber;//ç代ç |
| | | oItem.HEndFlag = true;//æ«çº§æ å¿ |
| | | oItem.HLevel = DBUtility.ClsPub.GetLevel(oItem.HNumber.Trim()); //ç级 |
| | |
| | | return objJsonResult; |
| | | } |
| | | |
| | | oCN.RunProc("update Gy_Material set HStopflag=1 where HItemID=" + HItemID); |
| | | oCN.RunProc("delete from Gy_Material where HItemID=" + HItemID); |
| | | oCN.Commit();//æäº¤äºå¡ |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | |
| | | string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg2 = sArray[0].ToString(); |
| | | string msg3 = sArray[1].ToString(); |
| | | string AddOrEdit = sArray[2].ToString(); //1æ°å¢3ç¼è¾ |
| | | //int ItemID = Convert.ToInt32(sArray[2]); |
| | | //string msg4 = sArray[2].ToString(); |
| | | //string msg5 = sArray[3].ToString(); |
| | | //ååºåå |
| | |
| | | string HRemark = list[0].HRemark; |
| | | bool HStopflag = list[0].HStopflag; |
| | | int ChangeHStopflag = 0; |
| | | |
| | | if (HStopflag) |
| | | { |
| | | ChangeHStopflag = 1; |
| | |
| | | //} |
| | | //ä¿å |
| | | //ä¿å宿¯åå¤ç |
| | | if (HItemID == 0) |
| | | if (AddOrEdit == "1") |
| | | { |
| | | oCN.BeginTran(); |
| | | oCN.RunProc("Insert into Xt_ORGANIZATIONS " + |
| | | " (HNumber,HName,HParentID" + |
| | | ",HStopflag,HMakeTime" + |
| | | ",HStopflag,HMakeTime,HItemID" + |
| | | ",HRemark) " + |
| | | " Values('" + HNumber + "','" + HName + "','" + HParentID.ToString() + |
| | | "','" + ChangeHStopflag + "'," + "getdate()" + |
| | | "','" + ChangeHStopflag + "'," + "getdate()" + ",'" + HItemID + "'" + |
| | | ",'" + HRemark + "')", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | |
| | | //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç |
| | | oCN.RunProc("Update Xt_ORGANIZATIONS set HStopflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCN.Commit(); |
| | | } |
| | | else |
| | | else if(AddOrEdit == "3") |
| | | { |
| | | int Stopflag; |
| | | if (HStopflag) |
| | | { |
| | | Stopflag = 1; |
| | | } |
| | | else |
| | | { |
| | | Stopflag = 0; |
| | | } |
| | | //è¥MAINDIéå¤åéæ°è·å |
| | | oCN.BeginTran(); |
| | | oCN.RunProc("Update Xt_ORGANIZATIONS set " + |
| | | " HNumber='" + HNumber + "'" + |
| | | ",HName='" + HName + "'" + |
| | | ",HParentID=" + HParentID + |
| | | ",HMakeTime=" + HMakeTime + |
| | | ",HStopflag='" + HStopflag + "'" + |
| | | ",HParentID='" + HParentID + "'" + |
| | | ",HMakeTime='" + HMakeTime + "'" + |
| | | ",HStopflag='" + Stopflag + "'" + |
| | | ",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCN.RunProc("Update Xt_ORGANIZATIONS set HStopflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCN.Commit(); |
| | |
| | | } |
| | | } |
| | | /// <summary> |
| | | /// è·åæå¤§HItemID |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Xt_ORGANIZATIONS/GetMaxHItemID")] |
| | | [HttpGet] |
| | | public object GetMaxHItemID() |
| | | { |
| | | try |
| | | { |
| | | |
| | | ds = oCN.RunProcReturn("select MAX(HItemID) from Xt_ORGANIZATIONS ", "Xt_ORGANIZATIONS"); |
| | | |
| | | |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | /// <summary> |
| | | /// ç»ç»è®¾ç½®å é¤åè½ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_ClassTimePrj where HStopflag=0 Order by HItemID ", "Gy_ClassTimePrj"); |
| | | ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_ClassTimePrjGroup where HStopflag=0 Order by HItemID ", "Gy_ClassTimePrjGroup"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "Select HItemID,HNumber ,HName from Gy_ClassTimePrj where HStopflag=0 "; |
| | | string sql1 = "Select HItemID,HNumber ,HName from Gy_ClassTimePrjGroup where HStopflag=0 "; |
| | | string sql = sql1 + sWhere; |
| | | ds = oCN.RunProcReturn(sql, "Gy_ClassTimePrj"); |
| | | ds = oCN.RunProcReturn(sql, "Gy_ClassTimePrjGroup"); |
| | | } |
| | | |
| | | //ds = webserver.GetUnitList(sWhere, ref DBUtility.ClsPub.sErrInfo); |
| | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// è·å计éåä½ç»å表 |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("Web/GetUnitGroupList_Json")] |
| | | [HttpGet] |
| | | public object GetUnitGroupList_Json(string Unit) |
| | | { |
| | | //sWhere = " Where HStopFlag=0 and HEndFlag=1"; |
| | | //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); |
| | | if (Unit != "" && Unit != null) |
| | | { |
| | | sWhere = sWhere + " and ( HNumber like '%" + Unit + "%' or HName like '%" + Unit + "%' ) "; |
| | | } |
| | | try |
| | | { |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("Select HItemID,HNumber 计éåä½ç»ä»£ç ,HName 计éåä½ç» from Gy_UnitGroup where HStopflag=0 Order by HItemID ", "Gy_UnitGroup"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "Select HItemID,HNumber 计éåä½ç»ä»£ç ,HName 计éåä½ç» from Gy_UnitGroup where HStopflag=0 and HEndFlag=1 "; |
| | | string sql = sql1 + sWhere; |
| | | ds = oCN.RunProcReturn(sql, "Gy_UnitGroup"); |
| | | } |
| | | |
| | | //ds = webserver.GetUnitList(sWhere, ref DBUtility.ClsPub.sErrInfo); |
| | | |
| | | |
| | | if (ds == null || ds.Tables[0].Rows.Count <= 0) |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "è·å失败" + DBUtility.ClsPub.sErrInfo; |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | else |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 1; |
| | | objjson.Message = "è·åæå!"; |
| | | objjson.data = ds.Tables[0]; |
| | | return objjson; |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "è·å失败" + ex.ToString(); |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// è·å客æ·å表 |
| | | /// </summary> |
| | | /// <returns></returns> |
| | |
| | | ",HWhID,HRoutingID,HBomID,HSecUnitID,HSecUnitRate" + |
| | | ",HHighStock,HLowStock,HSafeStock,HOrderPrice,HSalePrice" + |
| | | ",HKeepDays,HPlanPrice,HstdPrice,HQtyMin,HQtyMax" + |
| | | ",HSubjoin,HSubjoin2,HColor,HVersion,HEngName,HEngModel,HPropertyTypeID,HSPGroupID,HSPID,HMinPickQty) " + |
| | | ",HSubjoin,HSubjoin2,HColor,HVersion,HEngName,HEngModel,HPropertyTypeID,HSPGroupID,HSPID,HMinPickQty,HUSEORGID) " + |
| | | " Values('" + oModel.HNumber + "','" + oModel.HName + "','" + oModel.HHelpCode + "','" + oModel.HShortNumber + "'," + oModel.HParentID.ToString() + |
| | | ", " + oModel.HLevel.ToString() + "," + Convert.ToString(oModel.HEndFlag ? 1 : 0) + "," + Convert.ToString(oModel.HStopflag ? 1 : 0) + ",'" + oModel.HRemark + "'" + |
| | | ",'" + oModel.HModel + "'," + oModel.HUnitID.ToString() + "," + oModel.HMaterClsID.ToString() + "," + oModel.HMaterTypeID.ToString() + "," + oModel.HUnitGroupID.ToString() + |
| | | ", " + oModel.HWhID.ToString() + "," + oModel.HRoutingID.ToString() + "," + oModel.HBomID.ToString() + "," + oModel.HSecUnitID.ToString() + "," + oModel.HSecUnitRate.ToString() + |
| | | ", " + oModel.HHighStock.ToString() + "," + oModel.HLowStock.ToString() + "," + oModel.HSafeStock.ToString() + "," + oModel.HOrderPrice.ToString() + ",'" + oModel.HSalePrice + "'" + |
| | | ", " + oModel.HKeepDays.ToString() + "," + oModel.HPlanPrice.ToString() + "," + oModel.HstdPrice.ToString() + "," + oModel.HQtyMin.ToString() + "," + oModel.HQtyMax.ToString() + |
| | | ",'" + oModel.HSubjoin + "','" + oModel.HSubjoin2 + "','" + oModel.HColor + "','" + oModel.HVersion + "','" + oModel.HEngName + "','" + oModel.HEngModel + "'," + oModel.HPropertyTypeID.ToString() + "," + oModel.HSPGroupID.ToString() + "," + oModel.HSPID.ToString() + "," + oModel.HMinPickQty.ToString() + ")", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | ",'" + oModel.HSubjoin + "','" + oModel.HSubjoin2 + "','" + oModel.HColor + "','" + oModel.HVersion + "','" + oModel.HEngName + "','" + oModel.HEngModel + "'," + oModel.HPropertyTypeID.ToString() + "," + oModel.HSPGroupID.ToString() + "," + oModel.HSPID.ToString() + "," + oModel.HMinPickQty.ToString() + "," + oModel.HUSEORGID + ")", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç |
| | | oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" + oModel.HParentID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCn.Commit(); |
| | |
| | | public long HUnitGroupID; |
| | | public long HMaterTypeID; |
| | | public double HPlanPrice; |
| | | |
| | | public int HUSEORGID; |
| | | } |
| | | } |
| | |
| | | public string HEmpRate { get; set; } |
| | | public string HExamRate { get; set; } |
| | | public DateTime HHealthCardEDate { get; set; } |
| | | public long HUSEORGID { get; set; } |
| | | } |
| | | } |