/// <summary> /// [ISingleGridPage]删除表格数据 /// </summary> public void DeleteSelectedRows() { int selectedCount = Grid1.SelectedRowIndexArray.Length; if (selectedCount == 0) { Alert.ShowInTop("请至少选择一项纪录!", MessageBoxIcon.Warning); return; } object[] keys = Grid1.DataKeys[Grid1.SelectedRowIndex]; Entity.TransferPlan entity = DAL.TransferPlan.GetTransferPlan(int.Parse(HttpUtility.UrlEncode(keys[0].ToString()))); if (entity.StatusID == 2) { Alert.ShowInTop("审核通过的不能删除!", MessageBoxIcon.Information); return; } else { int BSuccess = DAL.TransferPlan.DeleteTransferPlan(int.Parse(HttpUtility.UrlEncode(keys[0].ToString()))); if (BSuccess == 1) { Alert.ShowInTop(" 操作成功!", MessageBoxIcon.Information); BindGrid(); } else { Alert.ShowInTop(" 操作失败!", MessageBoxIcon.Warning); } } }
private void LoadData(string thisGuid) { if (thisGuid != string.Empty) { Entity.TransferPlan entity = DAL.TransferPlan.GetTransferPlan(int.Parse(thisGuid)); txt_PlanNumber.Text = entity.PlanNumber; hid_htid.Text = entity.ContractID.ToString(); Entity.Contract con = DAL.Contract.GetContract(entity.ContractID); //txt_source.Text = DAL.Enterprise.GetEnterpriseName(con.ProduceID); txt_source.Text = con.ContractNumber; txt_Waste.Text = con.WasteName; hid_WasteCode.Text = con.WasteCode; Date_Start.SelectedDate = entity.StartDate; Date_End.SelectedDate = entity.EndDate; Date_Sign.SelectedDate = entity.ApprovalDate; NB_Amount.Text = entity.PlanAmount.ToString(); txt_Remark.Text = entity.Remark; if (entity.StatusID == 2) { txt_ContractNumber.Readonly = true; txt_PlanNumber.Readonly = true; txt_source.Readonly = true; txt_Waste.Readonly = true; Date_Start.Readonly = true; Date_End.Readonly = true; Date_Sign.Readonly = true; txt_Remark.Readonly = true; NB_Amount.Readonly = true; btn_save.Enabled = false; } } }
protected void btn_save_Click(object sender, EventArgs e) { string str = checkInfo(); if (str != "") { Alert.ShowInTop(str, MessageBoxIcon.Warning); } else { Entity.TransferPlan entity = new Entity.TransferPlan(); entity.ContractID = int.Parse(hid_htid.Text); //entity.PlanNumber = txt_PlanNumber.Text.Trim(); entity.WasteCode = hid_WasteCode.Text; entity.StartDate = Date_Start.SelectedDate; entity.EndDate = Date_End.SelectedDate; entity.ApprovalDate = Date_Sign.SelectedDate; entity.PlanAmount = decimal.Parse(NB_Amount.Text.Trim()); entity.CreateUser = Request.Cookies["Cookies"].Values["UserName"].ToString(); entity.UpdateUser = Request.Cookies["Cookies"].Values["UserName"].ToString(); entity.CreateDate = DateTime.Now; entity.UpdateDate = DateTime.Now; entity.StatusID = 1; entity.Remark = txt_Remark.Text.Trim(); entity.IYear = Date_Sign.SelectedDate.Value.Year; Entity.Contract contract = DAL.Contract.GetContract(entity.ContractID); string AreaCode = contract.ProduceArea; entity.Number = DAL.TransferPlan.GetMaxNumber(AreaCode, entity.IYear) + 1; entity.PlanNumber = txt_PlanNumber.Text.Trim(); //entity.PlanNumber = GeneratePlanNumber(AreaCode, entity.IYear, entity.Number.ToString()); int iReturn = 0; if (sGuid == string.Empty || sGuid == null) { iReturn = DAL.TransferPlan.AddTransferPlan(entity); } else { entity.PlanID = int.Parse(sGuid); iReturn = DAL.TransferPlan.UpdateTransferPlan(entity); } if (iReturn == 1) { Alert.ShowInTop(" 保存成功!", MessageBoxIcon.Information); // PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); } else { Alert.ShowInTop(" 保存失败!", MessageBoxIcon.Warning); } } }
public static int AddTransferPlan(Entity.TransferPlan entity) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); SqlTransactionHelper thelper = new SqlTransactionHelper(DAL.Config.con); IDbTransaction trans = thelper.StartTransaction(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@ContractID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ContractID.GetType().ToString()), entity.ContractID, 32), dbFactory.MakeInParam("@PlanNumber", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.PlanNumber.GetType().ToString()), entity.PlanNumber, 50), dbFactory.MakeInParam("@ApprovalDate", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ApprovalDate.GetType().ToString()), entity.ApprovalDate, 0), dbFactory.MakeInParam("@StartDate", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.StartDate.GetType().ToString()), entity.StartDate, 0), dbFactory.MakeInParam("@EndDate", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.EndDate.GetType().ToString()), entity.EndDate, 0), dbFactory.MakeInParam("@PlanAmount", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.PlanAmount.GetType().ToString()), entity.PlanAmount, 10), dbFactory.MakeInParam("@WasteCode", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.WasteCode.GetType().ToString()), entity.WasteCode, 50), dbFactory.MakeInParam("@Remark", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Remark.GetType().ToString()), entity.Remark, 0), dbFactory.MakeInParam("@CreateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.CreateUser.GetType().ToString()), entity.CreateUser, 50), dbFactory.MakeInParam("@CreateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.CreateDate.GetType().ToString()), entity.CreateDate, 0), dbFactory.MakeInParam("@UpdateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UpdateUser.GetType().ToString()), entity.UpdateUser, 50), dbFactory.MakeInParam("@UpdateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UpdateDate.GetType().ToString()), entity.UpdateDate, 0), dbFactory.MakeInParam("@StatusID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.StatusID.GetType().ToString()), entity.StatusID, 32), dbFactory.MakeInParam("@IYear", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.IYear.GetType().ToString()), entity.IYear, 32), dbFactory.MakeInParam("@Number", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Number.GetType().ToString()), entity.Number, 32) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_TransferPlan_Add", prams); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return(iReturn); }
/// <summary> /// /// </summary> /// <param name="PlanID"> </param> /// <returns></returns> public static Entity.TransferPlan GetTransferPlan(int PlanID) { Entity.TransferPlan entity = null; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [vTransferPlan] where PlanID='" + PlanID + "'", null); while (dataReader.Read()) { entity = new Entity.TransferPlan(); entity.PlanID = DataHelper.ParseToInt(dataReader["PlanID"].ToString()); entity.ContractID = DataHelper.ParseToInt(dataReader["ContractID"].ToString()); entity.PlanNumber = dataReader["PlanNumber"].ToString(); entity.ApprovalDate = DataHelper.ParseToDate(dataReader["ApprovalDate"].ToString()); entity.StartDate = DataHelper.ParseToDate(dataReader["StartDate"].ToString()); entity.EndDate = DataHelper.ParseToDate(dataReader["EndDate"].ToString()); entity.PlanAmount = decimal.Parse(dataReader["PlanAmount"].ToString()); entity.WasteCode = dataReader["WasteCode"].ToString(); entity.WasteName = dataReader["WasteName"].ToString(); entity.ProduceID = DataHelper.ParseToInt(dataReader["ProduceID"].ToString()); entity.ProduceName = dataReader["ProduceName"].ToString(); entity.Remark = dataReader["Remark"].ToString(); //entity.CreateUser = dataReader["CreateUser"].ToString(); //entity.CreateDate = DataHelper.ParseToDate(dataReader["CreateDate"].ToString()); //entity.UpdateUser = dataReader["UpdateUser"].ToString(); //entity.UpdateDate = DataHelper.ParseToDate(dataReader["UpdateDate"].ToString()); entity.StatusID = DataHelper.ParseToInt(dataReader["StatusID"].ToString()); entity.IYear = DataHelper.ParseToInt(dataReader["IYear"].ToString()); entity.Number = DataHelper.ParseToInt(dataReader["Number"].ToString()); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(entity); }
protected void Grid1_RowDoubleClick(object sender, GridRowClickEventArgs e) { if (Grid1.SelectedRowIndex != -1) { object[] keys = Grid1.DataKeys[Grid1.SelectedRowIndex]; hf_PlanID.Text = keys[0].ToString(); //txt_source.Text = keys[2].ToString(); Entity.TransferPlan plan = DAL.TransferPlan.GetTransferPlan(int.Parse(keys[0].ToString())); tb_PlanNumber.Text = plan.PlanNumber; txt_enterprise.Text = plan.ProduceName; hf_EID.Text = plan.ProduceID.ToString(); txt_Waste.Text = plan.WasteName; hid_WasteCode.Text = plan.WasteCode; Date_Start.MinDate = plan.StartDate; Date_Start.MaxDate = plan.EndDate; Window_DepartQuery.Hidden = true; //罐池号的DropdownList变化 BindDropdownList(plan.WasteCode); } }
protected void btn_Pass_Click(object sender, EventArgs e) { int selectedCount = Grid1.SelectedRowIndexArray.Length; if (selectedCount == 0) { Alert.ShowInTop("请至少选择一项纪录!", MessageBoxIcon.Warning); return; } object[] keys = Grid1.DataKeys[Grid1.SelectedRowIndex]; int PlanID = int.Parse(HttpUtility.UrlEncode(keys[0].ToString())); Entity.TransferPlan entity = DAL.TransferPlan.GetTransferPlan(PlanID); if (entity.StatusID == 2) { Alert.ShowInTop("该记录已经审核通过了!", MessageBoxIcon.Warning); return; } //Entity.TransferPlan entity = new Entity.TransferPlan(); //entity.PlanID = int.Parse(HttpUtility.UrlEncode(keys[0].ToString())); entity.StatusID = 2; entity.UpdateDate = DateTime.Now; entity.UpdateUser = Request.Cookies["Cookies"].Values["UserName"].ToString(); //先判断是否可行 int BSuccess = DAL.TransferPlan.UpdateTransferPlanStatus(entity.PlanID, entity.StatusID); if (BSuccess == 1) { Alert.ShowInTop(" 操作成功!", MessageBoxIcon.Information); BindGrid(); } else { Alert.ShowInTop(" 操作失败!", MessageBoxIcon.Warning); } }
protected string checkInfo() { string ret = ""; //if (txt_htnumber.Text.Trim() == "") //{ // ret += "请输入合同编号!"; //} //if (hid_qyid.Text.Trim() == "") //{ // ret += "请输入企业信息!"; //} //if (hid_qyid.Text.Trim() == "") // ret += "企业信息不在数据库中,请先进行信息维护!"; ////if (hid_qyid.Text.Trim() == "") //// ret += "企业信息不在数据库中,请先进行信息维护!"; //if (txt_jydate.Text == "") // ret += "请输入交易时间!"; //if (drop_type.SelectedValue.ToString().Trim() == "0") // ret += "请输入交易类型!"; //switch (drop_type.SelectedValue.ToString().Trim()) //{ // case "2"://购入新增量 // case "4"://在外地购入 // if (drop_source.SelectedValue.ToString().Trim() == "0") // ret += "请输入排污权来源类型!"; // if (txt_project.Text.Trim() == "") // ret += "请输入项目信息!"; // break; //} if (sGuid == string.Empty || sGuid == null) { string checkstr = "select * from TransferPlan where PlanNumber='" + txt_PlanNumber.Text.Trim() + "'"; DataSet dscheck = new MyDataOp().CreateDataSet(checkstr); if (dscheck != null) { if (dscheck.Tables[0].Rows.Count > 0) { ret += "该计划编号已存在!"; } } } else { string checkstr = "select * from TransferPlan where PlanNumber='" + txt_PlanNumber.Text.Trim() + "' and PlanID!='" + sGuid + "'"; DataSet dscheck = new MyDataOp().CreateDataSet(checkstr); if (dscheck != null) { if (dscheck.Tables[0].Rows.Count > 0) { ret += "计划编号不能重复!"; } } } int ContractID = 0; if (!string.IsNullOrEmpty(txt_source.Text)) { ContractID = DAL.Contract.GetContractIDByNumber(txt_source.Text); if (ContractID == 0) { ret += "请选择正确的合同编号!"; } else { hid_htid.Text = ContractID.ToString(); } } if (ContractID > 0) { Entity.Contract contract = DAL.Contract.GetContract(ContractID); if (Date_Start.SelectedDate < contract.StartDate) { ret += "开始时间早于合同的起始时间!"; } if (Date_End.SelectedDate > contract.EndDate) { ret += "结束时间晚于合同的结束时间!"; } if (Date_Start.SelectedDate > Date_End.SelectedDate) { ret += "结束时间小于开始时间!"; } decimal amount = contract.Amount; decimal Used = DAL.Contract.GetContractAmount(ContractID); decimal PlanAmount = decimal.Parse(NB_Amount.Text.Trim()); decimal Old = 0; if (!string.IsNullOrEmpty(sGuid)) { Entity.TransferPlan plan = DAL.TransferPlan.GetTransferPlan(int.Parse(sGuid)); Old = plan.PlanAmount; } if (Used + PlanAmount - Old > amount) { ret += "合同的剩余量不足,合同的剩余量为" + (amount - Used).ToString() + "!"; } } //判定计划数量之和是不是<合同的数量 return(ret); }
protected string checkInfo() { //判断各个ID是否存在,并赋值 string ret = ""; int PlanID = 0; if (!string.IsNullOrEmpty(tb_PlanNumber.Text.Trim())) { PlanID = DAL.TransferPlan.GetPlanIDByNumber(tb_PlanNumber.Text); if (PlanID == 0) { ret += "请选择正确的合同编号!"; } else { hf_PlanID.Text = PlanID.ToString(); } } if (PlanID > 0) { Entity.TransferPlan plan = DAL.TransferPlan.GetTransferPlan(PlanID); if (Date_Start.SelectedDate < plan.StartDate) { ret += "时间早于合同的起始时间!"; } if (Date_Start.SelectedDate > plan.EndDate) { ret += "时间晚于合同的结束时间!"; } decimal amount = plan.PlanAmount; decimal Used = DAL.TransferPlan.GetPlanAmount(PlanID); decimal PlanAmount = decimal.Parse(NB_Amount.Text.Trim()); decimal Old = 0; if (!string.IsNullOrEmpty(sGuid)) { Entity.WasteStorage ws = DAL.WasteStorage.GetWasteStorage(int.Parse(sGuid)); Old = ws.Amount; } Entity.Pond pond = DAL.Pond.GetPond(int.Parse(drop_Pond.SelectedValue.ToString())); decimal capacity = pond.Capacity; decimal used = pond.Used; if (used + PlanAmount - Old > capacity) { ret += "罐池的剩余量不足,罐池的剩余量为" + (capacity - used).ToString() + "!"; } if (Used + PlanAmount - Old > amount) { ret += "计划的剩余量不足,计划的剩余量为" + (amount - Used).ToString() + "!"; } } int DID = DAL.Driver.GetDriverID(txt_Driver.Text.Trim()); if (DID == 0) { ret += "请选择正确的驾驶员!"; } else { hf_DriverID.Text = DID.ToString(); } int CID = DAL.CarNumber.GetCarNumberID(txt_CarNumber.Text.Trim()); if (CID == 0) { ret += "请选择正确的车牌!"; } else { hf_CarID.Text = CID.ToString(); } int RID = DAL.User.GetUserID(txt_Receiver.Text.Trim(), 2); if (RID == 0) { ret += "请选择正确的签收人!"; } else { hf_ReceiverID.Text = RID.ToString(); } return(ret); }