public string UpdateWH_BorrowState(string BorrowID, ApproveState state) { int iState = Convert.ToInt32(state); string sErrorMsg = string.Empty; string sUpdateSql = "UPDATE WH_Borrow SET Status = " + iState.ToString() + " WHERE BorrowID = '" + BorrowID + "' "; sErrorMsg = this.BaseDataAccess.ExecuteDMLSQL(sUpdateSql); //借廖不更新 // if(sErrorMsg.Length == 0) // { // if(state == ApproveState.State_Approved) // { // string sSql = "SELECT a.* , b.* FROM WH_Borrow a left join WH_BorrowMaterial b on a.BorrowID = b.BorrowID WHERE a.BorrowID = '"+BorrowID+"'"; // DataTable dtBorrow = this.BaseDataAccess.GetDataTable ( sSql ); // // foreach(DataRow drBorrowEdit in dtBorrow.Rows) // { // //借料 // CInStoreMaterialDetailAccess pInStoreMaterialDetailAccess = new CInStoreMaterialDetailAccess(); // CInStoreMaterialDetail pOutStore = new CInStoreMaterialDetail(); // // // pOutStore.StoreOperateType = STOREOPERATETYPE.TYPE_OUT ; // pOutStore.OperateHistory = true; // pOutStore.InStockMaterialID = drBorrowEdit["InStockMaterialID"].ToString() ; // // // //pOutStore.QuantityInBinSet = cen.ChangeFromBaseUON(drBorrowEdit["ItemCode"].ToString(),drBorrowEdit["MaterialUomID"].ToString(),decimal.Parse(drIssueEdit["QuantityInBin"].ToString())); // // pInStoreMaterialDetailAccess.OperateStore(pOutStore); // } // } // } return(sErrorMsg); }
/// <summary> /// 登録選手の新しいインスタンスを生成します。 /// </summary> /// <param name="playerId">選手id。</param> /// <param name="teamId">団体id。</param> /// <param name="seasonId">年度id。</param> /// <param name="reservationNumber">予約番号。</param> /// <param name="reservationBranchNumber">予約番号枝番。</param> /// <param name="category">カテゴリー。</param> /// <param name="requestType">申請種別。</param> /// <param name="approveState">受領状態。</param> /// <param name="requestedDateTime">申請受付日。</param> /// <param name="playerRegistrationFee">選手登録料。</param> /// <param name="approveDateTime">受領日。</param> public RequestPlayer( int playerId, int teamId, int seasonId, ReservationNumber reservationNumber, int reservationBranchNumber, Category category, RequestType requestType, ApproveState approveState, DateTime requestedDateTime, PlayerRegistrationFee playerRegistrationFee, DateTime?approveDateTime ) { this.PlayerId = playerId; this.TeamId = teamId; this.SeasonId = seasonId; this.ReservationNumber = reservationNumber; this.ReservationBranchNumber = reservationBranchNumber; this.Category = category; this.RequestType = requestType; this.ApproveState = approveState; this.RequestedDateTime = requestedDateTime; this.PlayerRegistrationFee = playerRegistrationFee; this.ApproveDateTime = approveDateTime; }
void InitializeControlState() { if (PmsService.Instance.CurrentUser.Group.Name == "检测") { // BindMeasurementControl(); _ExecuteReportControlState = new ExecuteState(); _ExecuteReportControlState.Enter(this); } if (PmsService.Instance.CurrentUser.Group.Name == "评审") { //BindMeasurementControl(); //BindAuditControl(); _ExecuteReportControlState = new AuditState(); _ExecuteReportControlState.Enter(this); } if (PmsService.Instance.CurrentUser.Group.Name == "审批") { // BindMeasurementControl(); //BindAuditControl(); //BindApproveControl(); _ExecuteReportControlState = new ApproveState(); _ExecuteReportControlState.Enter(this); } }
public OsuBeatmap(Org.Json.JSONObject obj) { Approved = (ApproveState)obj.GetInt("approved"); ApprovedDate = obj.GetString("approved_date"); LastUpdate = obj.GetString("last_update"); Artist = obj.GetString("artist"); Id = obj.GetString("beatmap_id"); SetId = obj.GetString("beatmapset_id"); Bpm = obj.GetString("bpm"); Creator = obj.GetString("creator"); obj.GetString("difficultyrating"); Difficulty = new Difficulty(obj); HitLength = obj.GetLong("hit_length"); Source = obj.GetString("source"); Genre = (GenreType)obj.GetInt("genre_id"); Language = (LanguageType)obj.GetInt("language_id"); Title = obj.GetString("title"); TotalLength = obj.GetLong("total_length"); DifficultyName = obj.GetString("version"); MD5 = obj.GetString("file_md5"); Mode = (GameMode)obj.GetInt("mode"); m_tags = obj.GetString("tags"); FavoriteCount = obj.GetLong("favourite_count"); PlayCount = obj.GetLong("playcount"); PassCount = obj.GetLong("passcount"); //MaxCombo = obj.GetLong("max_combo"); }
public string UpdateTransferDEP2DEPState(string sTransferDEP2DEPID, ApproveState state) { int iState = Convert.ToInt32(state); string sErrorMsg = string.Empty; string sUpdateSql = "UPDATE WH_TransferDEP2DEP SET Status = " + iState.ToString() + " WHERE TransferDEP2DEPID = '" + sTransferDEP2DEPID + "' "; sErrorMsg = this.BaseDataAccess.ExecuteDMLSQL(sUpdateSql); return(sErrorMsg); }
public string Update_MR_MaterialRequisition_State(string sMRID, ApproveState state) { int iState = Convert.ToInt32(state); string sErrorMsg = string.Empty; string sUpdateSql = "UPDATE MR_MaterialRequisition SET Status = " + iState.ToString() + " WHERE MRID = '" + sMRID + "' "; sErrorMsg = this.BaseDataAccess.ExecuteDMLSQL(sUpdateSql); return(sErrorMsg); }
public string UpdateWH_IssueState(string IssueID, ApproveState state) { int iState = Convert.ToInt32(state); string sErrorMsg = string.Empty; string sUpdateSql = "UPDATE WH_Issue SET Status = " + iState.ToString() + "WHERE IssueID = '" + IssueID + "' "; sErrorMsg = this.BaseDataAccess.ExecuteDMLSQL(sUpdateSql); if (sErrorMsg.Length == 0) { if (state == ApproveState.State_Approved) { string sSql = "SELECT a.* , b.* FROM WH_Issue a left join WH_IssueMaterial b on a.IssueID = b.IssueID WHERE a.IssueID = '" + IssueID + "'"; DataTable IssueEdit = this.BaseDataAccess.GetDataTable(sSql); foreach (DataRow drIssueEdit in IssueEdit.Rows) { //出库 CInStoreMaterialDetailAccess pInStoreMaterialDetailAccess = new CInStoreMaterialDetailAccess(); CInStoreMaterialDetail pOutStore = new CInStoreMaterialDetail(); pOutStore.StoreOperateType = STOREOPERATETYPE.TYPE_OUT; pOutStore.OperateHistory = true; pOutStore.InStockMaterialID = drIssueEdit["InStockMaterialID"].ToString(); pOutStore.QuantityInBinSet = cen.ChangeToBaseUOM(drIssueEdit["ItemCode"].ToString(), drIssueEdit["MaterialUomID"].ToString(), decimal.Parse(drIssueEdit["FactIssuedQuantity"].ToString())); decimal decPreserveQuantityInFact = Convert.ToDecimal(drIssueEdit["PreserveQuantityInFact"] == DBNull.Value ? 0 : drIssueEdit["PreserveQuantityInFact"]); pOutStore.PreserveQuantitySet = cen.ChangeToBaseUOM(drIssueEdit["ItemCode"].ToString(), drIssueEdit["MaterialUomID"].ToString(), decPreserveQuantityInFact); pInStoreMaterialDetailAccess.OperateStore(pOutStore); //把数据写入财务接口 CInterfaceOfFinanceAccess pInterfaceOfFinanceAccess = new CInterfaceOfFinanceAccess(); CInterfaceOfFinance pInterfaceOfFinance = new CInterfaceOfFinance(); //库房 pInterfaceOfFinance.Location = drIssueEdit["WHID"].ToString(); //物资编码 pInterfaceOfFinance.ItemCode = drIssueEdit["ItemCode"].ToString(); //库位 pInterfaceOfFinance.BinNo = drIssueEdit["BINID"].ToString(); //单据号 pInterfaceOfFinance.BillNo = drIssueEdit["IssueNo"].ToString(); //操作人 pInterfaceOfFinance.Operater = drIssueEdit["CreateBy"].ToString(); //是出库还是入库 pInterfaceOfFinance.OperationDirection = DIRECTIONTYPE.TYPE_OUT; //单据类型 pInterfaceOfFinance.OperationType = pInterfaceOfFinanceAccess.GetBillType(BILLTYPE.TYPE_Issue); //基本单位的数量 pInterfaceOfFinance.Quantity = decimal.Parse(drIssueEdit["FactIssuedQuantity"].ToString()); //核算单价 pInterfaceOfFinance.UnitPriceStandard = decimal.Parse(drIssueEdit["UnitPriceStandard"].ToString()); pInterfaceOfFinanceAccess.OperateInterface(pInterfaceOfFinance); } } } return(sErrorMsg); }
public string UpdateAdjustOutState(string sAdjustOutID, ApproveState state) { int iState = Convert.ToInt32(state); string sErrorMsg = string.Empty; string sUpdateSql = "UPDATE WH_AdjustOut SET Status = " + iState.ToString() + " WHERE AdjustOutID = '" + sAdjustOutID + "' "; sErrorMsg = this.BaseDataAccess.ExecuteDMLSQL(sUpdateSql); if (sErrorMsg.Length == 0) { if (state == ApproveState.State_Approved) { string sSql = "SELECT a.* , b.WHID,b.AdjustOutNO,b.CreateBy FROM WH_AdjustOutMaterial a left join WH_AdjustOut b on a.AdjustOutID = b.AdjustOutID WHERE a.AdjustOutID = '" + sAdjustOutID + "'"; DataTable dtRejectMaterial = this.BaseDataAccess.GetDataTable(sSql); foreach (DataRow drRejectMaterial in dtRejectMaterial.Rows) { CInStoreMaterialDetailAccess pInStoreMaterialDetailAccess = new CInStoreMaterialDetailAccess(); //出库 CInStoreMaterialDetail pInStore = new CInStoreMaterialDetail(); pInStore.StoreOperateType = STOREOPERATETYPE.TYPE_OUT; pInStore.OperateHistory = true; pInStore.InStockMaterialID = drRejectMaterial["InStockMaterialID"].ToString(); pInStore.QuantityInBinSet = decimal.Parse(drRejectMaterial["QuantityReject"].ToString()); pInStoreMaterialDetailAccess.OperateStore(pInStore); //把数据写入财务接口 CInterfaceOfFinanceAccess pInterfaceOfFinanceAccess = new CInterfaceOfFinanceAccess(); CInterfaceOfFinance pInterfaceOfFinance = new CInterfaceOfFinance(); //库房 pInterfaceOfFinance.Location = drRejectMaterial["WHID"].ToString(); //物资编码 pInterfaceOfFinance.ItemCode = drRejectMaterial["ItemCode"].ToString(); //库位 pInterfaceOfFinance.BinNo = drRejectMaterial["BINID"].ToString(); //单据号 pInterfaceOfFinance.BillNo = drRejectMaterial["AdjustOutNO"].ToString(); //操作人 pInterfaceOfFinance.Operater = drRejectMaterial["CreateBy"].ToString(); //是出库还是入库 pInterfaceOfFinance.OperationDirection = DIRECTIONTYPE.TYPE_OUT; //单据类型 pInterfaceOfFinance.OperationType = pInterfaceOfFinanceAccess.GetBillType(BILLTYPE.TYPE_AdjustOut); //基本单位的数量 pInterfaceOfFinance.Quantity = decimal.Parse(drRejectMaterial["QuantityReject"].ToString()); //核算单价 pInterfaceOfFinance.UnitPriceStandard = decimal.Parse(drRejectMaterial["UnitPriceStandard"].ToString()); pInterfaceOfFinanceAccess.OperateInterface(pInterfaceOfFinance); } } } return(sErrorMsg); }
private void OnPartTask(object i_Obj) { BeginInvoke(new MessageHanlderDelegate(i_O => { var task = i_O as Task; if (task == null) { return; } _ExecuteReportControlState = new ExecuteState(); _ExecuteReportControlState.Enter(this); _Task = task; _ExecutionManager = new ExecutionManager(_Task); _CurrentTemplate = task.Part; if (_CurrentTemplate == null) { return; } Mediator.Mediator.Instance.NotifyColleagues(Execution.TaskStarted, task); CreateReportModel(); BindingTextControls(); RefreshCommentControls(); if (PmsService.Instance.CurrentUser.Group.Name == "检测") { LblTester.Text = PmsService.Instance.CurrentUser.Name; LblTestDate.Text = DateTime.Now.ToLongDateString(); _ExecuteReportControlState = new ExecuteState(); _ExecuteReportControlState.Enter(this); } if (PmsService.Instance.CurrentUser.Group.Name == "评审") { BindMeasurementControl(); LblAuditor.Text = PmsService.Instance.CurrentUser.Name; LblAuditDate.Text = DateTime.Now.ToLongDateString(); _ExecuteReportControlState = new AuditState(); _ExecuteReportControlState.Enter(this); } if (PmsService.Instance.CurrentUser.Group.Name == "审批") { BindMeasurementControl(); BindAuditControl(); LblApprover.Text = PmsService.Instance.CurrentUser.Name; LblApproveDate.Text = DateTime.Now.ToLongDateString(); _ExecuteReportControlState = new ApproveState(); _ExecuteReportControlState.Enter(this); } }), i_Obj); }
public string UpdateTransferBin2BinState(string sTransferBin2BinID, ApproveState state) { int iState = Convert.ToInt32(state); string sErrorMsg = string.Empty; string sUpdateSql = "UPDATE WH_TransferBin2Bin SET Status = " + iState.ToString() + " WHERE TransferBin2BinID = '" + sTransferBin2BinID + "' "; sErrorMsg = this.BaseDataAccess.ExecuteDMLSQL(sUpdateSql); if (sErrorMsg.Length == 0) { if (state == ApproveState.State_Approved) { string sSql = "SELECT a.* , b.WHID,c.VendorID,c.MFG,c.PartNo,c.Comment FROM WH_TransferBin2BinMaterial a left join WH_TransferBin2Bin b on a.TransferBin2BinID = b.TransferBin2BinID join WH_InStoreMaterialDetail c on c.InStockMaterialID = a.InStockMaterialID WHERE a.TransferBin2BinID = '" + sTransferBin2BinID + "'"; DataTable dtTransferBin2BinMaterial = this.BaseDataAccess.GetDataTable(sSql); foreach (DataRow drTransferBin2BinMaterial in dtTransferBin2BinMaterial.Rows) { //出库 CInStoreMaterialDetailAccess pInStoreMaterialDetailAccess = new CInStoreMaterialDetailAccess(); CInStoreMaterialDetail pOutStore = new CInStoreMaterialDetail(); pOutStore.StoreOperateType = STOREOPERATETYPE.TYPE_OUT; pOutStore.OperateHistory = false; pOutStore.InStockMaterialID = drTransferBin2BinMaterial["InStockMaterialID"].ToString(); pOutStore.QuantityInBinSet = Decimal.Parse(drTransferBin2BinMaterial["TransferQuantity"].ToString()); pInStoreMaterialDetailAccess.OperateStore(pOutStore); //入库 CInStoreMaterialDetail pInStore = new CInStoreMaterialDetail(); pInStore.StoreOperateType = STOREOPERATETYPE.TYPE_IN; pInStore.OperateHistory = false; pInStore.BINID = drTransferBin2BinMaterial["BINIDNew"].ToString(); pInStore.ItemCode = drTransferBin2BinMaterial["ItemCode"].ToString(); pInStore.POID = drTransferBin2BinMaterial["POID"].ToString(); pInStore.WHID = drTransferBin2BinMaterial["WHID"].ToString();; pInStore.UnitPricePOStandard = Decimal.Parse(drTransferBin2BinMaterial["UnitPriceStandard"].ToString()); pInStore.UnitPricePONatural = Decimal.Parse(drTransferBin2BinMaterial["UnitPriceNatural"].ToString()); pInStore.VendorID = drTransferBin2BinMaterial["VendorID"].ToString(); pInStore.MFG = drTransferBin2BinMaterial["MFG"].ToString(); pInStore.PartNo = drTransferBin2BinMaterial["PartNo"].ToString(); pInStore.Comment = drTransferBin2BinMaterial["Comment"].ToString(); pInStore.QuantityInBinSet = Decimal.Parse(drTransferBin2BinMaterial["TransferQuantity"].ToString()); pInStoreMaterialDetailAccess.OperateStore(pInStore); } } } return(sErrorMsg); }
public string UpdatePreserveState(string sPreserveID, ApproveState state) { int iState = Convert.ToInt32(state); string sErrorMsg = string.Empty; string sUpdateSql = "UPDATE WH_Preserve SET Status = " + iState.ToString() + " WHERE PreserveID = '" + sPreserveID + "' "; sErrorMsg = this.BaseDataAccess.ExecuteDMLSQL(sUpdateSql); if (sErrorMsg.Length == 0) { if (state == ApproveState.State_Approved) { string sSql = "SELECT a.* , b.WHID,b.IsPreserve FROM WH_PreserveMaterial a left join WH_Preserve b on a.PreserveID = b.PreserveID WHERE a.PreserveID = '" + sPreserveID + "'"; DataTable dtPreserveMaterial = this.BaseDataAccess.GetDataTable(sSql); bool bIsPreserve = Convert.ToBoolean(dtPreserveMaterial.Rows[0]["IsPreserve"]); foreach (DataRow drPreserveMaterial in dtPreserveMaterial.Rows) { CInStoreMaterialDetailAccess pInStoreMaterialDetailAccess = new CInStoreMaterialDetailAccess(); //入库 CInStoreMaterialDetail pInStore = new CInStoreMaterialDetail(); if (bIsPreserve == true) { pInStore.StoreOperateType = STOREOPERATETYPE.TYPE_IN; pInStore.PreserveQuantitySet = Decimal.Parse(drPreserveMaterial["QuantityPreserve"].ToString()); } else { pInStore.StoreOperateType = STOREOPERATETYPE.TYPE_OUT; pInStore.PreserveQuantitySet = Decimal.Parse(drPreserveMaterial["QuantityByCanceled"].ToString()); } pInStore.OperateHistory = false; pInStore.InStockMaterialID = drPreserveMaterial["InStockMaterialID"].ToString(); pInStore.QuantityInBinSet = 0; pInStoreMaterialDetailAccess.OperateStore(pInStore); } } } return(sErrorMsg); }
/// <summary> /// 更新收料单状态 /// </summary> /// <param name="sReceiveID">主键</param> /// <param name="state">目标状态</param> /// <returns></returns> public string UpdateReceiveState(string sReceiveID, ApproveState state) { int iState = Convert.ToInt32(state); string sErrorMsg = string.Empty; string sUpdateSql = "UPDATE WH_Receive SET Status = " + iState.ToString() + " WHERE ReceiveID = '" + sReceiveID + "' "; sErrorMsg = this.BaseDataAccess.ExecuteDMLSQL(sUpdateSql); if (sErrorMsg.Length == 0) { switch (state) { case ApproveState.State_Approved: { string[] sParams = { "ReceiveID" }; object[] objParamValues = { sReceiveID }; SqlDbType[] paramTypes = { SqlDbType.NVarChar }; bool bRetVal = this.BaseDataAccess.ExecuteSP("spUpdatePOMaterialANDOperateStoreMaterialDetail", sParams, objParamValues, paramTypes); if (bRetVal == false) { sErrorMsg = "OperateStoreFailed"; } // 写入财务接口 string sSelectSql = @"SELECT WHID,ItemCode,BINID,ReceiveNo,CreateBy,FactReceivedQuantity,UnitPriceStandard FROM WH_ReceiveMaterial INNER JOIN WH_Receive ON WH_ReceiveMaterial.ReceiveID = WH_Receive.ReceiveID WHERE WH_Receive.ReceiveID = '" + sReceiveID + "'"; DataTable dtReceiveMaterial = this.BaseDataAccess.GetDataTable(sSelectSql); foreach (DataRow dr in dtReceiveMaterial.Rows) { // 财务接口处理类 CInterfaceOfFinanceAccess pInterfaceOfFinanceAccess = new CInterfaceOfFinanceAccess(); // 财务接口实体 CInterfaceOfFinance pInterfaceOfFinance = new CInterfaceOfFinance(); pInterfaceOfFinance.Location = dr["WHID"].ToString(); pInterfaceOfFinance.ItemCode = dr["ItemCode"].ToString(); pInterfaceOfFinance.BinNo = dr["BINID"].ToString(); pInterfaceOfFinance.BillNo = dr["ReceiveNo"].ToString(); pInterfaceOfFinance.Operater = dr["CreateBy"].ToString(); pInterfaceOfFinance.Quantity = decimal.Parse(dr["FactReceivedQuantity"].ToString()); pInterfaceOfFinance.UnitPriceStandard = decimal.Parse(dr["UnitPriceStandard"].ToString()); pInterfaceOfFinance.OperationDirection = DIRECTIONTYPE.TYPE_IN; pInterfaceOfFinance.OperationType = pInterfaceOfFinanceAccess.GetBillType(BILLTYPE.TYPE_Receive); pInterfaceOfFinanceAccess.OperateInterface(pInterfaceOfFinance); } // =========================================== // // Modified By Liujun at 20081230 // 更新本次收料相关PO所有的 收料记录中的汇率,并且对更新后单价相同项进行合并 // #region 更新汇率 // DAEInStoreMaterialDetail dataEntity = new DAEInStoreMaterialDetail(); // string UpdateSql = @"UPDATE WH_Receive SET TotalPriceStandardlER = (SELECT TotalPriceStandardlER FROM WH_Receive WHERE ReceiveID = '" + sReceiveID + "') WHERE POID IN (SELECT POID FROM WH_Receive WHERE ReceiveID = '" + sReceiveID + "')"; // sErrorMsg = dataEntity.BaseDataAccess.ExecuteDMLSQL(UpdateSql); // if (sErrorMsg.Length == 0) // { // UpdateSql = "UPDATE WH_Receive SET TotalPriceStandarCUR = TotalPriceStandardlER * TotalPrice WHERE POID IN (SELECT POID FROM WH_Receive WHERE ReceiveID = '" + sReceiveID + "')"; // sErrorMsg = dataEntity.BaseDataAccess.ExecuteDMLSQL(UpdateSql); // } // if (sErrorMsg.Length == 0) // { // UpdateSql = @"UPDATE WH_ReceiveMaterial SET UnitPriceStandard = WH_Receive.TotalPriceStandardlER * UnitPrice // FROM WH_ReceiveMaterial INNER JOIN WH_Receive ON WH_Receive.ReceiveID = WH_ReceiveMaterial.ReceiveID // WHERE POID IN (SELECT POID FROM WH_Receive WHERE ReceiveID = '" + sReceiveID + "')"; // sErrorMsg = dataEntity.BaseDataAccess.ExecuteDMLSQL(UpdateSql); // } // if (sErrorMsg.Length == 0) // { // UpdateSql = @"UPDATE WH_InStoreMaterialDetail SET WH_InStoreMaterialDetail.UnitPricePOStandard = WH_ReceiveMaterial.UnitPriceStandard // FROM WH_InStoreMaterialDetail INNER JOIN WH_ReceiveMaterial ON WH_ReceiveMaterial.ItemCode = WH_InStoreMaterialDetail.ItemCode // INNER JOIN WH_Receive ON WH_Receive.ReceiveID = WH_ReceiveMaterial.ReceiveID AND WH_Receive.POID = WH_InStoreMaterialDetail.POID // WHERE WH_Receive.POID IN (SELECT POID FROM WH_Receive WHERE ReceiveID = '" + sReceiveID + "')"; // sErrorMsg = dataEntity.BaseDataAccess.ExecuteDMLSQL(UpdateSql); // } // // ============================================================= // // // Modified By Liujun at 20081228 // // 根据 Warehouse+ItemCode+PO+BinNo+UnitPrice 进行数量合并 // // 根据PO选出所有库存物资 // string SelectSql = "SELECT * FROM WH_InStoreMaterialDetail WHERE POID IN (SELECT POID FROM WH_Receive WHERE ReceiveID = '" + sReceiveID + "') ORDER BY ReceiveDate"; // DataTable dtPOInWarehouse = dataEntity.BaseDataAccess.GetDataTable(SelectSql); // // 待删除列表 放置 InStockMaterialID // System.Collections.ArrayList list = new System.Collections.ArrayList(); // for (int i = dtPOInWarehouse.Rows.Count - 1; i >= 0; i--) // { // for (int j = i - 1; j >= 0; j--) // { // if (dtPOInWarehouse.Rows[i]["WHID"].ToString() == dtPOInWarehouse.Rows[j]["WHID"].ToString() // && dtPOInWarehouse.Rows[i]["ItemCode"].ToString() == dtPOInWarehouse.Rows[j]["ItemCode"].ToString() // && dtPOInWarehouse.Rows[i]["POID"].ToString() == dtPOInWarehouse.Rows[j]["POID"].ToString() // && dtPOInWarehouse.Rows[i]["BinID"].ToString() == dtPOInWarehouse.Rows[j]["BinID"].ToString() // && dtPOInWarehouse.Rows[i]["UnitPricePOStandard"].ToString() == dtPOInWarehouse.Rows[j]["UnitPricePOStandard"].ToString()) // { // dtPOInWarehouse.Rows[j]["QuantityInBin"] = decimal.Parse(dtPOInWarehouse.Rows[i]["QuantityInBin"].ToString()) + decimal.Parse(dtPOInWarehouse.Rows[j]["QuantityInBin"].ToString()); // // 分别对比较行与被比较行修改临时状态 // dtPOInWarehouse.Rows[j]["Status"] = 1; // // 放入删除列表中 // list.Add(dtPOInWarehouse.Rows[i]["InStockMaterialID"].ToString()); // // 在内存数据表中删除 // dtPOInWarehouse.Rows.RemoveAt(i); // break; // } // } // } // // 更新数据 // foreach (DataRow dr in dtPOInWarehouse.Rows) // { // if (dr["Status"].ToString() == "1") // { // UpdateSql = "UPDATE WH_InStoreMaterialDetail SET QuantityInBin = " + dr["QuantityInBin"].ToString() + " WHERE InStockMaterialID ='" + dr["InStockMaterialID"].ToString() + "'"; // sErrorMsg = dataEntity.BaseDataAccess.ExecuteDMLSQL(UpdateSql); // } // } // // 删除数据(数量变为0) // string DeleteSql = string.Empty; // foreach (string str in list) // { // //DeleteSql = "UPDATE WH_InStoreMaterialDetail SET QuantityInBin = 0 WHERE InStockMaterialID ='" + str + "'"; // DeleteSql = "DELETE FROM WH_InStoreMaterialDetail WHERE InStockMaterialID ='" + str + "'"; // sErrorMsg = dataEntity.BaseDataAccess.ExecuteDMLSQL(DeleteSql); // } // #endregion // // =========================================== // // // =========================================== // // // Modified By Liujun at 20030315 // // 更新本次收料相关PO的物资Remark。 // UpdateSql = @"UPDATE POMaterial // // SET POMaterial.Remark = WH_ReceiveMaterial.Comment // // FROM POMaterial INNER JOIN WH_Receive ON POMaterial.POID = WH_Receive.POID // INNER JOIN WH_ReceiveMaterial ON WH_Receive.ReceiveID = WH_ReceiveMaterial.ReceiveID // AND WH_ReceiveMaterial.ItemCode = POMaterial.ItemCode // WHERE WH_Receive.ReceiveID = '" + sReceiveID + "' AND WH_ReceiveMaterial.Comment <> ''"; // sErrorMsg = dataEntity.BaseDataAccess.ExecuteDMLSQL(UpdateSql); // // =========================================== // break; } } } return(sErrorMsg); }
/// <summary> /// 更新直达收料单状态 /// </summary> /// <param name="sReceiveID">主键</param> /// <param name="state">目标状态</param> /// <returns></returns> public string UpdateDirectState(string sIssueID, ApproveState state) { int iState = Convert.ToInt32(state); string sErrorMsg = string.Empty; string sUpdateSql = "UPDATE WH_Receive SET Status = " + iState.ToString() + " WHERE ReceiveID = '" + sIssueID + "' "; sErrorMsg = this.BaseDataAccess.ExecuteDMLSQL(sUpdateSql); sUpdateSql = "UPDATE WH_Issue SET Status = " + iState.ToString() + " WHERE IssueID = '" + sIssueID + "' "; sErrorMsg = this.BaseDataAccess.ExecuteDMLSQL(sUpdateSql); switch (state) { case ApproveState.State_Approved: { // 收料更新(库存,入库) string[] sParams = { "ReceiveID" }; object[] objParamValues = { sIssueID }; SqlDbType[] paramTypes = { SqlDbType.NVarChar }; bool bRetVal = this.BaseDataAccess.ExecuteSP("spUpdatePOMaterialANDOperateStoreMaterialDetail", sParams, objParamValues, paramTypes); if (bRetVal == false) { sErrorMsg = "OperateStoreFailed"; } string sSql = "SELECT a.* , b.WHID,b.POID,b.ReceiveNo,b.CreateBy FROM WH_ReceiveMaterial a left join WH_Receive b on a.ReceiveID = b.ReceiveID WHERE a.ReceiveID = '" + sIssueID + "'"; DataTable dtReceiveMaterial = this.BaseDataAccess.GetDataTable(sSql); CInStoreMaterialDetailAccess pInStoreMaterialDetailAccess = new CInStoreMaterialDetailAccess(); // 财务接口处理类 CInterfaceOfFinanceAccess pInterfaceOfFinanceAccess = new CInterfaceOfFinanceAccess(); foreach (DataRow drReceiveMaterial in dtReceiveMaterial.Rows) { // 财务接口实体 CInterfaceOfFinance pInStoreInterfaceOfFinance = new CInterfaceOfFinance(); pInStoreInterfaceOfFinance.Location = drReceiveMaterial["WHID"].ToString(); pInStoreInterfaceOfFinance.ItemCode = drReceiveMaterial["ItemCode"].ToString(); pInStoreInterfaceOfFinance.BinNo = drReceiveMaterial["BINID"].ToString(); pInStoreInterfaceOfFinance.BillNo = drReceiveMaterial["ReceiveNo"].ToString(); pInStoreInterfaceOfFinance.Operater = drReceiveMaterial["CreateBy"].ToString(); pInStoreInterfaceOfFinance.Quantity = decimal.Parse(drReceiveMaterial["FactReceivedQuantity"].ToString()); pInStoreInterfaceOfFinance.UnitPriceStandard = decimal.Parse(drReceiveMaterial["UnitPriceStandard"].ToString()); pInStoreInterfaceOfFinance.OperationDirection = DIRECTIONTYPE.TYPE_IN; pInStoreInterfaceOfFinance.OperationType = pInterfaceOfFinanceAccess.GetBillType(BILLTYPE.TYPE_Receive); pInterfaceOfFinanceAccess.OperateInterface(pInStoreInterfaceOfFinance); // 出库 CInStoreMaterialDetail pOutStore = new CInStoreMaterialDetail(); pOutStore.StoreOperateType = STOREOPERATETYPE.TYPE_OUT; pOutStore.OperateHistory = true; pOutStore.BINID = drReceiveMaterial["BINID"].ToString(); pOutStore.ItemCode = drReceiveMaterial["ItemCode"].ToString(); pOutStore.POID = drReceiveMaterial["POID"].ToString(); pOutStore.WHID = drReceiveMaterial["WHID"].ToString(); pOutStore.UnitPricePONatural = Decimal.Parse(drReceiveMaterial["UnitPriceNatural"].ToString()); pOutStore.UnitPricePOStandard = Decimal.Parse(drReceiveMaterial["UnitPriceStandard"].ToString()); pOutStore.QuantityInBinSet = Decimal.Parse(drReceiveMaterial["FactReceivedQuantity"].ToString()); pInStoreMaterialDetailAccess.OperateStore(pOutStore); // 财务接口实体 CInterfaceOfFinance pOutStoreInterfaceOfFinance = new CInterfaceOfFinance(); pOutStoreInterfaceOfFinance.Location = drReceiveMaterial["WHID"].ToString(); pOutStoreInterfaceOfFinance.ItemCode = drReceiveMaterial["ItemCode"].ToString(); pOutStoreInterfaceOfFinance.BinNo = drReceiveMaterial["BINID"].ToString(); pOutStoreInterfaceOfFinance.BillNo = drReceiveMaterial["ReceiveNo"].ToString(); pOutStoreInterfaceOfFinance.Operater = drReceiveMaterial["CreateBy"].ToString(); pOutStoreInterfaceOfFinance.Quantity = decimal.Parse(drReceiveMaterial["FactReceivedQuantity"].ToString()); pOutStoreInterfaceOfFinance.UnitPriceStandard = decimal.Parse(drReceiveMaterial["UnitPriceStandard"].ToString()); pOutStoreInterfaceOfFinance.OperationDirection = DIRECTIONTYPE.TYPE_OUT; pOutStoreInterfaceOfFinance.OperationType = pInterfaceOfFinanceAccess.GetBillType(BILLTYPE.TYPE_Issue); pInterfaceOfFinanceAccess.OperateInterface(pOutStoreInterfaceOfFinance); } break; } } return(sErrorMsg); }
/// <summary> /// 刷新工具栏 /// </summary> protected virtual void RefreshTool() { switch (BillState) { case State.None: this.toolStripNew.Enabled = true; this.toolStripDelete.Enabled = false; this.toolStripEdit.Enabled = false; this.toolStripCancel.Enabled = false; this.toolStripSave.Enabled = false; this.toolStripApprove.Enabled = false; this.toolStripReApprove.Enabled = false; this.toolStripPrint.Enabled = false; this.toolStripExport.Enabled = false; this.toolStripCancellation.Enabled = false; this.picFlag.Image = null; break; case State.New: goto case State.Edit; case State.Edit: this.toolStripNew.Enabled = false; this.toolStripDelete.Enabled = false; this.toolStripEdit.Enabled = false; this.toolStripCancel.Enabled = true; this.toolStripSave.Enabled = true; this.toolStripApprove.Enabled = false; this.toolStripReApprove.Enabled = false; this.toolStripPrint.Enabled = false; this.toolStripExport.Enabled = false; this.toolStripCancellation.Enabled = false; if (billState == State.New) { this.picFlag.Image = Resource1.Adding; } else { this.picFlag.Image = Resource1.Editing; } break; case State.Query: bool canEdit = CanEdit(); this.toolStripNew.Enabled = true; this.toolStripDelete.Enabled = CanDelete(); this.toolStripEdit.Enabled = canEdit; this.toolStripCancel.Enabled = false; this.toolStripSave.Enabled = false; ApproveState approveState = IsApprove(); CancellationState cancellationState = IsCancelled(); this.picFlag.Image = Resource1.Saved; switch (approveState) { case ApproveState.No: this.toolStripApprove.Enabled = true; this.toolStripReApprove.Enabled = false; break; case ApproveState.Yes: this.toolStripApprove.Enabled = false; this.toolStripReApprove.Enabled = true; this.picFlag.Image = Resource1.Approved; break; case ApproveState.Error: this.toolStripApprove.Enabled = false; this.toolStripReApprove.Enabled = false; break; } this.toolStripPrint.Enabled = true; this.toolStripExport.Enabled = true; switch (cancellationState) { case CancellationState.No: //如果单据未审核并且可以修改 才能被取消,否则不能再取消 if (approveState != ApproveState.Yes && canEdit) { this.toolStripCancellation.Enabled = true; } else { this.toolStripCancellation.Enabled = false; } break; case CancellationState.Yes: //取消了不能再修改,也不能再做其它操作 this.toolStripNew.Enabled = true; this.toolStripDelete.Enabled = false; this.toolStripEdit.Enabled = false; this.toolStripCancel.Enabled = false; this.toolStripSave.Enabled = false; this.toolStripApprove.Enabled = false; this.toolStripReApprove.Enabled = false; this.toolStripPrint.Enabled = false; this.toolStripExport.Enabled = false; this.toolStripCancellation.Enabled = false; this.picFlag.Image = Resource1.Cancelled; break; case CancellationState.Error: this.toolStripCancellation.Enabled = false; break; } break; } }
public string UpdateReturnState(string sReturnID, ApproveState state) { int iState = Convert.ToInt32(state); string sErrorMsg = string.Empty; string sUpdateSql = "UPDATE WH_Return SET Status = " + iState.ToString() + " WHERE ReturnID = '" + sReturnID + "' "; sErrorMsg = this.BaseDataAccess.ExecuteDMLSQL(sUpdateSql); if (sErrorMsg.Length == 0) { if (state == ApproveState.State_Approved) { string sSql = @" SELECT WH_ReturnMaterial.ItemCode , WH_ReturnMaterial.POID , WH_ReturnMaterial.BINID , WH_ReturnMaterial.UnitPriceNatural , WH_ReturnMaterial.UnitPriceStandard , WH_ReturnMaterial.FactReturnQuantity , WH_ReturnMaterial.depreciationRate , WH_InStoreMaterialDetail.VendorID, WH_Return.WHIDReceive ,WH_Return.CreateBy ,WH_Return.ReturnNo FROM WH_Return inner join WH_ReturnMaterial on WH_Return.ReturnID = WH_ReturnMaterial.ReturnID inner join WH_IssueMaterial on WH_ReturnMaterial.IssueMaterialID = WH_IssueMaterial.IssueMaterialID inner join WH_InStoreMaterialDetail on WH_IssueMaterial.InStockMaterialID = WH_InStoreMaterialDetail.InStockMaterialID WHERE WH_ReturnMaterial.ReturnID = '" + sReturnID + "'"; DataTable dt = _da.GetDataTable(sSql); foreach (DataRow dr in dt.Rows) { //入库 CInStoreMaterialDetailAccess pInStoreMaterialDetailAccess = new CInStoreMaterialDetailAccess(); CInStoreMaterialDetail pInStore = new CInStoreMaterialDetail(); pInStore.StoreOperateType = STOREOPERATETYPE.TYPE_IN; pInStore.OperateHistory = true; pInStore.BINID = dr["BINID"].ToString(); pInStore.VendorID = dr["VendorID"].ToString(); pInStore.ItemCode = dr["ItemCode"].ToString(); pInStore.POID = dr["POID"].ToString(); pInStore.WHID = dr["WHIDReceive"].ToString(); decimal dUnitPriceNatural = Decimal.Parse(dr["UnitPriceNatural"].ToString()); decimal dUnitPriceStandard = Decimal.Parse(dr["UnitPriceStandard"].ToString()); decimal dDepreciationRate = Decimal.Parse(dr["depreciationRate"].ToString()); pInStore.UnitPricePONatural = dUnitPriceNatural * dDepreciationRate; pInStore.UnitPricePOStandard = dUnitPriceStandard * dDepreciationRate; pInStore.QuantityInBinSet = Decimal.Parse(dr["FactReturnQuantity"].ToString()); pInStoreMaterialDetailAccess.OperateStore(pInStore); //把数据写入财务接口 CInterfaceOfFinanceAccess pInterfaceOfFinanceAccess = new CInterfaceOfFinanceAccess(); CInterfaceOfFinance pInterfaceOfFinance = new CInterfaceOfFinance(); //库房 pInterfaceOfFinance.Location = dr["WHIDReceive"].ToString(); //物资编码 pInterfaceOfFinance.ItemCode = dr["ItemCode"].ToString(); //库位 pInterfaceOfFinance.BinNo = dr["BINID"].ToString(); //单据号 pInterfaceOfFinance.BillNo = dr["ReturnNo"].ToString(); //操作人 pInterfaceOfFinance.Operater = dr["CreateBy"].ToString(); //是出库还是入库 pInterfaceOfFinance.OperationDirection = DIRECTIONTYPE.TYPE_IN; //单据类型 pInterfaceOfFinance.OperationType = pInterfaceOfFinanceAccess.GetBillType(BILLTYPE.TYPE_Return); //基本单位的数量 pInterfaceOfFinance.Quantity = decimal.Parse(dr["FactReturnQuantity"].ToString()); //核算单价 pInterfaceOfFinance.UnitPriceStandard = decimal.Parse(dr["UnitPriceStandard"].ToString()); pInterfaceOfFinanceAccess.OperateInterface(pInterfaceOfFinance); } } } return(sErrorMsg); }
private void OnPartReportSpecified(object i_Obj) { BeginInvoke(new Mediator.MessageHanlderDelegate(i_O => { var partReport = i_O as PartReport; if (partReport == null) { return; } _Task = partReport.Task; _PartReport = partReport; _CurrentTemplate = partReport.Task.Part; if (_CurrentTemplate == null) { return; } _DataSource = new List <ExecuteDimensionEntityViewModel>(); PmsService.Instance.PopulateDimensionsForReport(_PartReport); foreach (var en in _PartReport.Dimensions) { _DataSource.Add(new ExecuteDimensionEntityViewModel(en)); } if (_CurrentTemplate.Dimensions.Count > 0) { _SeletedDimension = _PartReport.Dimensions[0]; } dataGridView1.DataSource = _DataSource; btnCreateReport.Text = @"保存报告"; BindingTextControls(); // RefreshCommentControls(); if (PmsService.Instance.CurrentUser.Group.Name == "检测") { BindMeasurementControl(); LblTester.Text = PmsService.Instance.CurrentUser.Name; LblTestDate.Text = DateTime.Now.ToLongDateString(); _ExecuteReportControlState = new ExecuteState(); _ExecuteReportControlState.Enter(this); } if (PmsService.Instance.CurrentUser.Group.Name == "评审") { BindMeasurementControl(); BindAuditControl(); LblAuditor.Text = PmsService.Instance.CurrentUser.Name; LblAuditDate.Text = DateTime.Now.ToLongDateString(); _ExecuteReportControlState = new AuditState(); _ExecuteReportControlState.Enter(this); } if (PmsService.Instance.CurrentUser.Group.Name == "审批") { BindMeasurementControl(); BindAuditControl(); BindApproveControl(); LblApprover.Text = PmsService.Instance.CurrentUser.Name; LblApproveDate.Text = DateTime.Now.ToLongDateString(); _ExecuteReportControlState = new ApproveState(); _ExecuteReportControlState.Enter(this); } }), i_Obj); }
/// <summary> /// 更新库间转料状态 /// </summary> /// <param name="PkValue"></param> /// <param name="state"></param> /// <returns></returns> public string UpdateWH_TransferWH2WHState(string PkValue, ApproveState state) { int iState = Convert.ToInt32(state); string sErrorMsg = string.Empty; string sUpdateSql = "UPDATE WH_TransferWH2WH SET Status = " + iState.ToString() + " WHERE TransferWH2WHID = '" + PkValue + "' "; sErrorMsg = this.BaseDataAccess.ExecuteDMLSQL(sUpdateSql); if (sErrorMsg.Length == 0) { switch (state) { case ApproveState.State_Approved: { string sql = @"SELECT a.* , b.* ,c.VendorID,d.PartNo,d.MFG FROM WH_TransferWH2WHMaterial a left join WH_TransferWH2WH b on a.TransferWH2WHID = b.TransferWH2WHID left join PurchaseOrder c on a.POID = c.POID left join Material as d on d.ItemCode = a.ItemCode WHERE a.TransferWH2WHID = '" + PkValue + "'"; DataTable dt = this.BaseDataAccess.GetDataTable(sql); #region for (int i = 0; i < dt.Rows.Count; i++) { //出库 // 构造库存操作实体 DataEntity.CInStoreMaterialDetail Out_entity = new DataEntity.CInStoreMaterialDetail(); // 调用库存操作连接类 DataEntity.CInStoreMaterialDetailAccess storeAccess = new CInStoreMaterialDetailAccess(); Out_entity.StoreOperateType = DataEntity.STOREOPERATETYPE.TYPE_OUT; Out_entity.BINID = dt.Rows[i]["BINIDOld"].ToString(); Out_entity.InStockMaterialID = dt.Rows[i]["InStockMaterialID"].ToString();; Out_entity.ItemCode = dt.Rows[i]["ItemCode"].ToString(); Out_entity.POID = dt.Rows[i]["POID"].ToString(); Out_entity.QuantityInBinSet = Decimal.Parse(dt.Rows[i]["TransferQuantity"].ToString()); //库位数量 = 原库位数量 - 转料数量 Out_entity.UnitPricePONatural = Decimal.Parse(dt.Rows[i]["UnitPriceNatural"].ToString()); Out_entity.UnitPricePOStandard = Decimal.Parse(dt.Rows[i]["UnitPriceStandard"].ToString()); Out_entity.WHID = dt.Rows[i]["WHIDOld"].ToString(); Out_entity.VendorID = dt.Rows[i]["VendorID"].ToString(); //供应商ID Out_entity.PartNo = dt.Rows[i]["PartNo"].ToString(); //制造编号 Out_entity.MFG = dt.Rows[i]["MFG"].ToString(); //制造商 //Out_entity.PreserveQuantitySet = 0; //预留数量 Out_entity.OperateHistory = true; //把数据写入财务接口 CInterfaceOfFinanceAccess pInterfaceOfFinanceAccess = new CInterfaceOfFinanceAccess(); CInterfaceOfFinance pInterfaceOfFinance = new CInterfaceOfFinance(); //库房 pInterfaceOfFinance.Location = dt.Rows[i]["WHIDOld"].ToString(); //物资编码 pInterfaceOfFinance.ItemCode = dt.Rows[i]["ItemCode"].ToString(); //库位 pInterfaceOfFinance.BinNo = dt.Rows[i]["BINIDOld"].ToString(); //单据号 pInterfaceOfFinance.BillNo = dt.Rows[i]["TransferWH2WHNO"].ToString(); //操作人 pInterfaceOfFinance.Operater = dt.Rows[i]["CreateBy"].ToString(); //是出库还是入库 pInterfaceOfFinance.OperationDirection = DIRECTIONTYPE.TYPE_OUT; //单据类型 pInterfaceOfFinance.OperationType = pInterfaceOfFinanceAccess.GetBillType(BILLTYPE.TYPE_TransferWH2WH); //基本单位的数量 pInterfaceOfFinance.Quantity = decimal.Parse(dt.Rows[i]["TransferQuantity"].ToString()); //核算单价 pInterfaceOfFinance.UnitPriceStandard = decimal.Parse(dt.Rows[i]["UnitPriceStandard"].ToString()); pInterfaceOfFinanceAccess.OperateInterface(pInterfaceOfFinance); bool IsOK = storeAccess.OperateStore(Out_entity); //入库 DataEntity.CInStoreMaterialDetail In_entity = new DataEntity.CInStoreMaterialDetail(); In_entity.StoreOperateType = DataEntity.STOREOPERATETYPE.TYPE_IN; In_entity.BINID = dt.Rows[i]["BINIDNew"].ToString(); In_entity.ItemCode = dt.Rows[i]["ItemCode"].ToString(); In_entity.POID = dt.Rows[i]["POID"].ToString(); In_entity.QuantityInBinSet = Decimal.Parse(dt.Rows[i]["TransferQuantity"].ToString()); //库位数量 = 原库位数量 - 转料数量 In_entity.UnitPricePONatural = Decimal.Parse(dt.Rows[i]["UnitPriceNatural"].ToString()); In_entity.UnitPricePOStandard = Decimal.Parse(dt.Rows[i]["UnitPriceStandard"].ToString()); In_entity.WHID = dt.Rows[i]["WHIDNew"].ToString(); In_entity.VendorID = dt.Rows[i]["VendorID"].ToString(); //供应商ID In_entity.PartNo = dt.Rows[i]["PartNo"].ToString(); //制造编号 In_entity.MFG = dt.Rows[i]["MFG"].ToString(); //制造商 In_entity.OperateHistory = true; //把数据写入财务接口 //库房 pInterfaceOfFinance.Location = dt.Rows[i]["WHIDNew"].ToString(); //物资编码 pInterfaceOfFinance.ItemCode = dt.Rows[i]["ItemCode"].ToString(); //库位 pInterfaceOfFinance.BinNo = dt.Rows[i]["BINIDNew"].ToString(); //单据号 pInterfaceOfFinance.BillNo = dt.Rows[i]["TransferWH2WHNO"].ToString(); //操作人 pInterfaceOfFinance.Operater = dt.Rows[i]["CreateBy"].ToString(); //是出库还是入库 pInterfaceOfFinance.OperationDirection = DIRECTIONTYPE.TYPE_IN; //单据类型 pInterfaceOfFinance.OperationType = pInterfaceOfFinanceAccess.GetBillType(BILLTYPE.TYPE_TransferWH2WH); //基本单位的数量 pInterfaceOfFinance.Quantity = decimal.Parse(dt.Rows[i]["TransferQuantity"].ToString()); //核算单价 pInterfaceOfFinance.UnitPriceStandard = decimal.Parse(dt.Rows[i]["UnitPriceStandard"].ToString()); pInterfaceOfFinanceAccess.OperateInterface(pInterfaceOfFinance); IsOK = storeAccess.OperateStore(In_entity); } #endregion break; } } } return(sErrorMsg); }