public void reloadAll() { List <SCInvoice> lstContractInvoice = new List <SCInvoice>(); if (SCMain.ContractOid > 0) { objContract = SCBase.searchContracts(SCMain.ContractOid); objContract.listContractOptions = ContractOption.getContractOption(objContract.ContractOID); //Loc du lieu bi sai List <ContractOption> listWrong = new List <ContractOption>(); Dictionary <String, String> dicContractOptions = new Dictionary <String, String>(); foreach (ContractOption tmp in objContract.listContractOptions) { if (dicContractOptions.ContainsKey(tmp.toString())) { listWrong.Add(tmp); } else { dicContractOptions.Add(tmp.toString(), "1"); } } ///Thuc hien xoa objContract.deleteContractOptionWrong(objContract.ContractOID, listWrong); //Reload lai data objContract.listContractOptions = ContractOption.getContractOption(objContract.ContractOID); // List <Int32> lstInvoiceType = new List <Int32>(); lstInvoiceType.Add(0); lstInvoiceType.Add(1); lstContractInvoice = SCInvoiceUtil.getContractInvoice(ContractFrm.objContract.ContractOID, lstInvoiceType, true); objContract.listSCContractRemark = SCContractRemark.getRemark(objContract.ContractOID); } else { objContract = new Contract(); } this.loadComboboxData(); this.loadContractData(); myCulture = objGlobal.CultureInfo; // this.loadVehice(); this.contractOption1.loadDataGrid(); this.contractOption1.loadTree(); this.contractDataFrm.fillData(); objContract.listSCContractRemark = (objContract.listSCContractRemark == null) ? new List <SCContractRemark>() : objContract.listSCContractRemark; //Invoice invoicesFrm.setCheckDefault(); invoicesFrm.fillDataGrid(lstContractInvoice); //Remark remarkFrm.loadRemark(objContract.listSCContractRemark); }
private void btnSave_Click(object sender, EventArgs e) { this.updateContract(); this.vehicleDataTab.saveVehicle(); if (objContract.VehiId.VehiId <= 0) { // MessageBox.Show("Select Vehicle"); return; } //Update category this.contractOption1.saveOptionCategories(); //Update contract data objContract = contractDataFrm.saveContractData(); this.remarkFrm.saveContractRemark(); bool tmp = false; tmp = objContract.saveContract(); // MessageBox.Show(tmp.ToString()); objContract = SCBase.searchContracts(objContract.ContractOID); this.loadComboboxData(); this.loadContractData(); //Load lai data objContract.listContractOptions = ContractOption.getContractOption(objContract.ContractOID); objContract.listSCContractRemark = SCContractRemark.getRemark(objContract.ContractOID); objContract.listSCContractRemark = (objContract.listSCContractRemark == null) ? new List <SCContractRemark>() : objContract.listSCContractRemark; //Remark this.remarkFrm.loadRemark(objContract.listSCContractRemark); }
private void btnNew_Click(object sender, EventArgs e) { DialogResult result = MessageBox.Show("Do you want to create new version?", "Warning", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { if (objContract.ContractOID != 0) { // get old object Contract oldContract = new Contract(); oldContract = SCBase.searchContracts(SCMain.ContractOid); //update status old then save oldContract.ContractStatus = ContractStatus.Deactivated; //Load danh sach ContractOption va ZSC_SubcontractorContractRisk List <ContractOption> oldContractOptions = ContractOption.getContractOption(SCMain.ContractOid); List <ZSC_SubcontractorContractRisk> oldContractRisk = ZSC_SubcontractorContractRisk.getSubcontractorContractRisk(SCMain.ContractOid); oldContract.saveContract(); // new object objContract.ContractOID = 0; objContract.VersionNo = objContract.VersionNo + 1; this.updateContract(); //Tao list [ZSC_ContractOption] objContract.listContractOptions = oldContractOptions; if (objContract.listContractOptions != null && objContract.listContractOptions.Count > 0) { foreach (ContractOption objOptionDetail in objContract.listContractOptions) { objOptionDetail.isInsert = true; } } //Tao list [ZSC_SubcontractorContractRisk] objContract.SubcontractorContractRisks = oldContractRisk; bool tmp = objContract.saveContract(); if (tmp) { this.loadComboboxData(); this.loadContractData(); //Load Data this.loadVehice(); this.contractOption1.loadDataGrid(); this.contractOption1.loadTree(); this.contractDataFrm.fillData(); } } } else { //MessageBox.Show("Ha ha"); } }
private bool invoiceContract(Contract objContract, bool bDraft, bool bManual, String Payer, int InvoiceSeqNr, bool bCapital) { bool bRet = true; clsAppConfig objAppConfig = new clsAppConfig(); clsGlobalVariable objGlobal = new clsGlobalVariable(); SCInvoice objInv = new SCInvoice(); clsSqlFactory hSql = new clsSqlFactory(); objInv.InvoiceSeqNr = InvoiceSeqNr; if (Payer == "") { if (objContract.InvoiceCustId != null) { objInv.CustNo = objContract.InvoiceCustId.CustNr; } else { objInv.CustNo = objContract.ContractCustId.CustNr; } } else { objInv.CustNo = objAppConfig.getNumberParam("ZSCCAPPAYE", Payer, "V1", ""); } objInv.DCustNo = objContract.ContractCustId.CustNr; objInv.UnitId = objContract.InvoiceSiteId.strValue1; objInv.ContractOID = objContract.ContractOID; objInv.ExtOrderId = objContract.ExtContractNo; if (objInv.ExtOrderId.Length > 10) { objInv.ExtOrderId = objInv.ExtOrderId.Substring(0, 10); } objInv.SalesType = objAppConfig.getStringParam("ZSCSETTING", "TRTYPE", "C3", ""); objInv.SmanId = objContract.RespSmanId.SmanId; objInv.TPCODE = objContract.ContractPaymentData.PaymentTerm.strValue1; objInv.TPTIME = objAppConfig.getNumberParam("MAKSUEHDOT", objInv.TPCODE, "V1", ""); if (objContract.CostCenter.strValue1 != "") { hSql.NewCommand("select isnull(a.C4,'') from CORW a where a.CODAID='ZSCCOSTCC' and a.C3=? and a.C5=? "); hSql.Com.Parameters.Add("UNITID", objContract.SiteId.strValue1); hSql.Com.Parameters.Add("COSTCENTER", objContract.CostCenter.strValue1); hSql.ExecuteReader(); if (hSql.Read()) { objInv.DeptId = hSql.Reader.GetString(0); } } objInv.Payer = Payer; objInv.OUserId = objGlobal.DMSFirstUserName; objInv.VehiId = objContract.VehiId.VehiId; objInv.Note = objContract.ContractNo.ToString() + "/" + objContract.VersionNo.ToString() + "/" + objInv.InvoiceSeqNr.ToString(); hSql.NewCommand("select isnull(a.C4,''), isnull(a.C5,'') from CORW a, VEHI b where a.CODAID='ZSCCONV' and a.C2='VEHICLASS2BTYPE' and a.C3=b.CLASS and b.VEHIID=? "); hSql.Com.Parameters.Add("VEHIID", objContract.VehiId.VehiId); hSql.ExecuteReader(); if (hSql.Read()) { objInv.BTYPE = hSql.Reader.GetString(0); objInv.PartPostFix = hSql.Reader.GetString(1); } if (objContract.ContractPaymentData.PaymentGroupingLevel == PaymentGroupingType.Customer) { objInv.BTYPE = "0"; } else { if (objContract.PaymentCollecType == PaymentCollectionType.Transfer) { objInv.BTYPE = objAppConfig.getStringParam("ZSCSETTING", "INVCAT4", "C3", ""); } else if (objContract.PaymentCollecType == PaymentCollectionType.Debit) { objInv.BTYPE = objAppConfig.getStringParam("ZSCSETTING", "INVCAT5", "C3", ""); } else if (objContract.PaymentCollecType == PaymentCollectionType.Plain) { objInv.BTYPE = objAppConfig.getStringParam("ZSCSETTING", "INVCAT6", "C3", ""); } else { if (bManual == true) { objInv.BTYPE = objAppConfig.getStringParam("ZSCSETTING", "INVCAT2", "C3", ""); } else { objInv.BTYPE = objAppConfig.getStringParam("ZSCSETTING", "INVCAT1", "C3", ""); } } } if (Payer != "") { objInv.BTYPE = objAppConfig.getStringParam("ZSCCAPPAYE", Payer, "C3", ""); } if (objContract.NextInvoiceDate == DateTime.MinValue) { objInv.BILLD = DateTime.Now; } else { objInv.BILLD = objContract.NextInvoiceDate; } int nInvoiceDay = objContract.ContractPaymentData.InvoiceDate; if (nInvoiceDay <= 0) { nInvoiceDay = objAppConfig.getNumberParam("ZSCSETTING", "INVDATE", "V1", ""); } if (objInv.BILLD.Day > nInvoiceDay) { objInv.BILLD = new DateTime(objInv.BILLD.Year, objInv.BILLD.Month, nInvoiceDay); objInv.BILLD = objInv.BILLD.AddMonths(1); } else if (objInv.BILLD.Day < nInvoiceDay) { objInv.BILLD = new DateTime(objInv.BILLD.Year, objInv.BILLD.Month, nInvoiceDay); } objInv.CBILLD = new DateTime(objInv.BILLD.Year, objInv.BILLD.Month, objInv.BILLD.Day); switch (objContract.ContractPaymentData.PaymentPeriod.strValue1) { case PaymentPeriodType.Quarterly: objInv.NBILLD = objInv.CBILLD.AddMonths(3); break; case PaymentPeriodType.HalfYear: objInv.NBILLD = objInv.CBILLD.AddMonths(6); break; case PaymentPeriodType.Yearly: objInv.NBILLD = objInv.CBILLD.AddMonths(12); break; default: objInv.NBILLD = objInv.CBILLD.AddMonths(1); break; } objInv.DELD = objInv.BILLD; addInvoiceText(hSql, objContract, ref objInv); objContract.listContractOptions = ContractOption.getContractOption(objContract.ContractOID); //objContract.loadDetail(); addInvoiceRows(objContract, ref objInv, bCapital); hSql.Close(); bRet = objInv.saveOrder(bDraft); if ((bRet == true) && (bManual == true)) { if (bDraft == true) { openInvoice(objInv.UnitId, objInv.SSALID, objInv.SRECNO); } else { openInvoicePDF(objInv.UnitId, objInv.SRECNO); } } return(bRet); }