/// <summary> /// /// </summary> /// <returns></returns> public static List <Entity.Pond> GetAllPondEx() { List <Entity.Pond> list = new List <Entity.Pond>(); DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [vPond]", null); while (dataReader.Read()) { Entity.Pond entity = new Entity.Pond(); entity.PondID = DataHelper.ParseToInt(dataReader["PondID"].ToString()); entity.Name = dataReader["Name"].ToString(); entity.Capacity = decimal.Parse(dataReader["Capacity"].ToString()); entity.Used = decimal.Parse(dataReader["Used"].ToString()); entity.Stores = dataReader["Stores"].ToString(); entity.Number = DataHelper.ParseToInt(dataReader["Number"].ToString()); entity.IsDelete = DataHelper.ParseToInt(dataReader["IsDelete"].ToString()); list.Add(entity); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(list); }
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]; //Entity.WasteStorage entity = new Entity.WasteStorage(); //entity.StorageID = int.Parse(HttpUtility.UrlEncode(keys[0].ToString())); //entity.Status = 2; //entity.UpdateDate = DateTime.Now; //entity.UpdateUser = Request.Cookies["Cookies"].Values["UserName"].ToString(); int StorageID = int.Parse(HttpUtility.UrlEncode(keys[0].ToString())); Entity.WasteStorage entity = DAL.WasteStorage.GetWasteStorage(StorageID); if (entity.Status >= 2) { Alert.ShowInTop("该记录已经审核通过了!", MessageBoxIcon.Warning); return; } //entity.StorageID = int.Parse(HttpUtility.UrlEncode(keys[0].ToString())); entity.Status = 3; entity.UpdateDate = DateTime.Now; entity.UpdateUser = Request.Cookies["Cookies"].Values["UserName"].ToString(); entity.CreateDate = DateTime.Now; entity.CreateUser = Request.Cookies["Cookies"].Values["UserName"].ToString(); //先判断是否可行 int PondID = entity.PondID; Entity.Pond pond = DAL.Pond.GetPond(PondID); decimal Capacity = pond.Capacity; decimal Used = pond.Used; //decimal Used = DAL.PondUsed.GetPondUsedAmount(PondID); decimal Now = Used + entity.Amount; decimal Remain = Capacity - Now; if (Remain < 0) { Alert.ShowInTop("罐池余量不足!", MessageBoxIcon.Warning); return; } //int BSuccess = DAL.WasteStorage.UpdateWasteStorageStatus(entity.StorageID,DateTime.Parse(entity.UpdateDate.ToString()),entity.UpdateUser, entity.Status); int BSuccess = DAL.WasteStorage.PassWasteStorage(entity, Now); if (BSuccess == 1) { Alert.ShowInTop(" 操作成功!", MessageBoxIcon.Information); BindGrid(); } else { Alert.ShowInTop(" 操作失败!", MessageBoxIcon.Warning); } }
private string checkInput() { string msg = ""; if (NB_New.Text.Trim() == "") { msg += "请输入倒库量!"; } int PondID1 = int.Parse(drop_Source.SelectedValue.Trim()); Entity.Pond entity1 = DAL.Pond.GetPond(PondID1); decimal Change = decimal.Parse(NB_New.Text.Trim()); decimal Capacity = entity1.Capacity; decimal used = entity1.Used; //decimal used = DAL.PondUsed.GetPondUsedAmount(entity1.PondID); decimal Remain = used - Change; if (Remain < 0) { msg += "来源库库存不够!"; } int PondID2 = int.Parse(drop_To.SelectedValue.Trim()); Entity.Pond entity2 = DAL.Pond.GetPond(PondID2); decimal Capacity2 = entity2.Capacity; decimal used2 = entity2.Used; //decimal used2 = DAL.PondUsed.GetPondUsedAmount(entity2.PondID); decimal Remain2 = Capacity2 - used2 - Change; if (Remain2 < 0) { msg += "修正后的导入库已超所设的容量!"; } return(msg); }
protected void GetInfo() { string WasteCode = drop_Waste.SelectedValue; DataTable dt = DAL.Pond.QueryPond(WasteCode, ""); drop_Source.DataTextField = "Name"; drop_Source.DataValueField = "PondID"; drop_Source.DataSource = dt; drop_Source.DataBind(); int PondID = int.Parse(drop_Source.SelectedValue.Trim()); Entity.Pond entity = DAL.Pond.GetPond(PondID); decimal Used = entity.Used; //decimal Used = DAL.PondUsed.GetPondUsedAmount(PondID); //txt_Used1.Text = entity.Used.ToString(); txt_Capacity1.Text = entity.Capacity.ToString(); txt_Capacity2.Text = entity.Capacity.ToString(); txt_Used1.Text = Used.ToString(); txt_Used2.Text = Used.ToString(); drop_To.DataTextField = "Name"; drop_To.DataValueField = "PondID"; drop_To.DataSource = dt; drop_To.DataBind(); //int PondID2 = int.Parse(drop_To.SelectedValue.Trim()); //Entity.Pond entity2 = DAL.Pond.GetPond(PondID2); //txt_Used2.Text = entity.Used.ToString(); //txt_Capacity2.Text = entity2.Capacity.ToString(); }
/// <summary> /// /// </summary> /// <param name="PondID"> </param> /// <returns></returns> public static Entity.Pond GetPondByName(string Name) { Entity.Pond entity = null; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [vPond] where Name='" + Name + "'", null); while (dataReader.Read()) { entity = new Entity.Pond(); entity.PondID = DataHelper.ParseToInt(dataReader["PondID"].ToString()); entity.Name = dataReader["Name"].ToString(); entity.Capacity = decimal.Parse(dataReader["Capacity"].ToString()); entity.Stores = dataReader["Stores"].ToString(); entity.Number = DataHelper.ParseToInt(dataReader["Number"].ToString()); entity.Used = decimal.Parse(dataReader["Used"].ToString()); //entity.Remain = decimal.Parse(dataReader["Remain"].ToString()); entity.IsDelete = DataHelper.ParseToInt(dataReader["IsDelete"].ToString()); entity.WasteName = dataReader["WasteName"].ToString(); entity.Status = dataReader["Status"].ToString(); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(entity); }
public static int UpdatePond(Entity.Pond 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("@PondID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.PondID.GetType().ToString()), entity.PondID, 32), dbFactory.MakeInParam("@Name", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Name.GetType().ToString()), entity.Name, 20), dbFactory.MakeInParam("@Capacity", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Capacity.GetType().ToString()), entity.Capacity, 10), dbFactory.MakeInParam("@Stores", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Stores.GetType().ToString()), entity.Stores, 20), dbFactory.MakeInParam("@Number", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Number.GetType().ToString()), entity.Number, 32), //dbFactory.MakeInParam("@Remain", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Remain.GetType().ToString()),entity.Remain,10), dbFactory.MakeInParam("@IsDelete", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.IsDelete.GetType().ToString()), entity.IsDelete, 32) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_Pond_Update", prams); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return(iReturn); }
protected void drop_Pond_Change(object sender, EventArgs e) { // 设置LinkButtonField的点击客户端事件 if (drop_Pond.SelectedIndex > -1) { Entity.Pond entity = DAL.Pond.GetPond(int.Parse(drop_Pond.SelectedValue)); txt_WasteName.Text = entity.WasteName; } }
protected string checkInfo() { //判断各个ID是否存在,并赋值 string ret = ""; int DID = DAL.Driver.GetDriverID(txt_Driver.Text.Trim()); if (DID == 0) { ret += "请选择正确的驾驶员!"; } else { hf_DriverID.Text = DID.ToString(); } int RID = DAL.User.GetUserID(txt_Consignor.Text.Trim(), 3); if (RID == 0) { ret += "请选择正确的发货人!"; } else { hf_ConsignorID.Text = RID.ToString(); } int EID = DAL.Enterprise.GetEnterpriseID(txt_enterprise.Text.Trim()); if (EID == 0) { ret += "请选择正确的收货单位!"; } else { hf_EID.Text = EID.ToString(); } int CID = DAL.CarNumber.GetCarNumberID(txt_CarNumber.Text.Trim()); if (CID == 0) { ret += "请选择正确的车牌!"; } else { hf_CarID.Text = CID.ToString(); } Entity.Pond pond = DAL.Pond.GetPond(int.Parse(drop_Pond.SelectedValue.ToString())); decimal amount = decimal.Parse(NB_Amount.Text.Trim()); decimal used = pond.Used; if (used < amount) { ret += "罐池的库存量不足,罐池的库存量为" + used.ToString() + "!"; } return(ret); }
protected void drop_pond_SelectedIndexChanged(object sender, EventArgs e) { int PondID = int.Parse(drop_pond.SelectedValue.Trim()); Entity.Pond entity = DAL.Pond.GetPond(PondID); txt_Waste.Text = entity.WasteName; //txt_Old.Text = entity.Used.ToString(); txt_Capacity.Text = entity.Capacity.ToString(); txt_Old.Text = entity.Used.ToString(); //txt_Old.Text = DAL.PondUsed.GetPondUsedAmount(PondID).ToString(); }
protected void drop_To_SelectedIndexChanged(object sender, EventArgs e) { int PondID = int.Parse(drop_To.SelectedValue.Trim()); Entity.Pond entity = DAL.Pond.GetPond(PondID); //txt_Used2.Text = entity.Used.ToString(); txt_Capacity2.Text = entity.Capacity.ToString(); decimal Used = entity.Used; //decimal Used = DAL.PondUsed.GetPondUsedAmount(PondID); txt_Used2.Text = Used.ToString(); }
private void LoadData(string sId) { if (sId != string.Empty) { Entity.Pond entity = DAL.Pond.GetPond(int.Parse(sId)); txt_name.Text = entity.Name; //txt_pwNO.Text = ds.Tables[0].Rows[0]["排污权证号"].ToString(); txt_areacode.Text = entity.Capacity.ToString(); drop_Waste.SelectedValue = entity.Stores; CheckStop.SelectedValue = entity.IsDelete.ToString(); Orderid.Text = entity.Number.ToString(); //hfUsed.Text = entity.Used.ToString(); } }
protected void btn_save_Click(object sender, EventArgs e) { string msg = checkInput(); if (msg != "") { Alert.Show(msg); return; } else { Entity.Pond entity = new Entity.Pond(); entity.Name = txt_name.Text.Trim(); // = ds.Tables[0].Rows[0]["单位全称"].ToString(); entity.Number = int.Parse(Orderid.Text.ToString()); entity.Capacity = decimal.Parse(txt_areacode.Text.Trim()); // = ds.Tables[0].Rows[0]["单位法人代码"].ToString(); entity.IsDelete = int.Parse(CheckStop.SelectedValue.ToString()); entity.Stores = drop_Waste.SelectedValue.Trim(); if (string.IsNullOrEmpty(sGuid)) { //Add int success = DAL.Pond.AddPond(entity); if (success == 1) { Alert.ShowInTop(" 保存成功!", MessageBoxIcon.Information); PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); } else { Alert.ShowInTop(" 保存失败!", MessageBoxIcon.Warning); } } else { //Update entity.PondID = int.Parse(sGuid); //decimal used = decimal.Parse(hfUsed.Text); //entity.Remain = entity.Capacity - used; int success = DAL.Pond.UpdatePond(entity); if (success == 1) { Alert.ShowInTop(" 修改成功!", MessageBoxIcon.Information); PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); } else { Alert.ShowInTop(" 修改失败!", MessageBoxIcon.Warning); } } } }
private void BindDropdownList() { DataTable dt = DAL.Pond.GetPartPond(2); drop_Pond.DataTextField = "Name"; drop_Pond.DataValueField = "PondID"; drop_Pond.DataSource = dt; drop_Pond.DataBind(); if (drop_Pond.SelectedIndex == 0) { Entity.Pond pond = DAL.Pond.GetPond(int.Parse(drop_Pond.SelectedValue)); txt_Waste.Text = pond.WasteName; hid_WasteCode.Text = pond.Stores; } }
protected void Page_Init(object sender, EventArgs e) { List <Entity.Waste> items = DAL.Waste.GetPartWasteEx(2); //this.ddlGrade.DataSource = grade; //this.ddlGrade.DataTextField = "Name"; //this.ddlGrade.DataValueField = "ID"; //this.ddlGrade.DataBind(); for (int i = 0; i < items.Count; i++) { FineUI.ListItem li = new FineUI.ListItem(); Entity.Waste item = items[i]; li.Text = item.WasteName; li.Value = item.WasteName; this.drop_Product.Items.Insert(i, li); } //List<Entity.Waste> items2 = DAL.Waste.GetPartWasteEx(3); //for (int i = 0; i < items2.Count; i++) //{ // FineUI.ListItem li = new FineUI.ListItem(); // Entity.Waste item = items2[i]; // li.Text = item.WasteName; // li.Value = item.WasteName; // this.drop_NewWaste.Items.Insert(i, li); //} //List<Entity.Pond> items3 = DAL.Pond.GetAllPondEx(); List <Entity.Pond> items3 = DAL.Pond.GetAllPondEx2(2); for (int i = 0; i < items3.Count; i++) { FineUI.ListItem li = new FineUI.ListItem(); Entity.Pond item = items3[i]; li.Text = item.Name; li.Value = item.Name; this.drop_Pond2.Items.Insert(i, li); } //DataTable table2 = DAL.Pond.GetAllPond(); DataTable table2 = DAL.Pond.GetPartPond(1); drop_Pond.DataSource = table2; drop_Pond.DataTextField = "Name"; drop_Pond.DataValueField = "PondID"; drop_Pond.DataBind(); }
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 OutID = int.Parse(HttpUtility.UrlEncode(keys[0].ToString())); Entity.ProductOut entity = DAL.ProductOut.GetProductOut(OutID); if (entity.Status == 2) { Alert.ShowInTop("该记录已经审核通过了!", MessageBoxIcon.Warning); return; } entity.Status = 2; entity.UpdateDate = DateTime.Now; entity.UpdateUser = Request.Cookies["Cookies"].Values["UserName"].ToString(); entity.CreateDate = DateTime.Now; entity.CreateUser = Request.Cookies["Cookies"].Values["UserName"].ToString(); //先判断是否可行 int PondID = entity.PondID; Entity.Pond pond = DAL.Pond.GetPond(PondID); decimal Used = pond.Used; decimal Now = Used - entity.Amount; if (Now < 0) { Alert.ShowInTop("罐池库存不足!", MessageBoxIcon.Warning); return; } int BSuccess = DAL.ProductOut.PassProductOut(entity, Now); if (BSuccess == 1) { Alert.ShowInTop(" 操作成功!", MessageBoxIcon.Information); BindGrid(); } else { Alert.ShowInTop(" 操作失败!", MessageBoxIcon.Warning); } }
protected void btn_save_Click(object sender, EventArgs e) { string msg = checkInput(); if (msg != "") { Alert.Show(msg); return; } else { Entity.PondLog entity = new Entity.PondLog(); entity.SourceID = int.Parse(drop_Source.SelectedValue.Trim()); entity.ToID = int.Parse(drop_To.SelectedValue.Trim()); entity.CreateDate = DateTime.Now; entity.CreateUser = Request.Cookies["Cookies"].Values["UserName"].ToString(); entity.Amount = decimal.Parse(NB_New.Text.Trim()); //Add //decimal capacity = decimal.Parse(txt_Capacity.Text.Trim()); int PondID1 = int.Parse(drop_Source.SelectedValue.Trim()); Entity.Pond entity1 = DAL.Pond.GetPond(PondID1); decimal used1 = entity1.Used; //decimal used1 = DAL.PondUsed.GetPondUsedAmount(entity1.PondID); decimal Capacity = entity1.Capacity; int PondID2 = int.Parse(drop_To.SelectedValue.Trim()); Entity.Pond entity2 = DAL.Pond.GetPond(PondID2); decimal used2 = entity2.Used; //decimal used2 = DAL.PondUsed.GetPondUsedAmount(entity2.PondID); decimal Capacity2 = entity2.Capacity; decimal U1 = used1 - entity.Amount; decimal U2 = used2 + entity.Amount; //decimal R1 = Capacity - used1 + entity.Amount; //decimal R2 = Capacity2 - used2 - entity.Amount; //int success = DAL.PondLog.AddPondLog(entity, U1,R1,U2,R2); int success = DAL.PondLog.AddPondLogEx(entity, U1, U2); if (success == 1) { Alert.ShowInTop(" 保存成功!", MessageBoxIcon.Information); PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); } else { Alert.ShowInTop(" 保存失败!", MessageBoxIcon.Warning); } } }
private void InitDropDownList()//清空详细页面中所有的TextBox { DataTable dt = DAL.Pond.GetAllPond(); drop_pond.DataTextField = "Name"; drop_pond.DataValueField = "PondID"; drop_pond.DataSource = dt; drop_pond.DataBind(); int PondID = int.Parse(drop_pond.SelectedValue.Trim()); Entity.Pond entity = DAL.Pond.GetPond(PondID); txt_Waste.Text = entity.WasteName; //txt_Old.Text = entity.Used.ToString(); txt_Capacity.Text = entity.Capacity.ToString(); //txt_Old.Text = DAL.PondUsed.GetPondUsedAmount(PondID).ToString(); txt_Old.Text = entity.Used.ToString(); }
private string checkInput() { string msg = ""; if (NB_New.Text.Trim() == "") { msg += "请输入修正后的量!"; } int PondID = int.Parse(drop_pond.SelectedValue.Trim()); Entity.Pond entity = DAL.Pond.GetPond(PondID); decimal Capacity = entity.Capacity; decimal Fix = decimal.Parse(NB_New.Text.Trim()); decimal Remain = Capacity - Fix; if (Remain < 0) { msg += "修正量已超所设的容量!"; } return(msg); }
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); }
protected void drop_PondChange(object sender, EventArgs e) { Entity.Pond pond = DAL.Pond.GetPond(int.Parse(drop_Pond.SelectedValue)); txt_Waste.Text = pond.WasteName; hid_WasteCode.Text = pond.Stores; }
protected void Page_Load(object sender, EventArgs e) { PageBase pb = new PageBase(); if (Request.Cookies["Cookies"] == null) { Response.Redirect("../../Login.aspx"); } if (!IsPostBack) { if (drop_Pond.SelectedIndex == 0) { Entity.Pond entity = DAL.Pond.GetPond(int.Parse(drop_Pond.SelectedValue)); txt_WasteName.Text = entity.WasteName; } List <Entity.Waste> items = DAL.Waste.GetPartWasteEx(2); string WasteName1 = ""; if (items.Count > 0) { WasteName1 = items[0].WasteName; } //List<Entity.Waste> items2 = DAL.Waste.GetPartWasteEx(3); //string WasteName2 = ""; //if (items2.Count > 0) //{ // WasteName2= items2[0].WasteName; //} List <Entity.Pond> items3 = DAL.Pond.GetAllPondEx2(2); string Pond = ""; if (items3.Count > 0) { Pond = items3[0].Name; } string deleteScript = GetDeleteScript(); JObject defaultObj = new JObject(); defaultObj.Add("DetailID", 9999); defaultObj.Add("WasteName", WasteName1); defaultObj.Add("Amount", 10); defaultObj.Add("Name", Pond); defaultObj.Add("Delete", String.Format("<a href=\"javascript:;\" onclick=\"{0}\"><img src=\"{1}\"/></a>", deleteScript, IconHelper.GetResolvedIconUrl(Icon.Delete))); // 在第一行新增一条数据 btnNew.OnClientClick = Grid1.GetAddNewRecordReference(defaultObj, AppendToEnd); // 删除选中行按钮 btnDelete.OnClientClick = Grid1.GetNoSelectionAlertReference("请至少选择一项!") + deleteScript; //BindGrid(); //string deleteScript2 = GetDeleteScriptEx(); //JObject defaultObj2 = new JObject(); //defaultObj2.Add("FWID", 9999); //defaultObj2.Add("WasteName2", WasteName2); //defaultObj2.Add("Result2", 10); //defaultObj2.Add("Delete2", String.Format("<a href=\"javascript:;\" onclick=\"{0}\"><img src=\"{1}\"/></a>", deleteScript2, IconHelper.GetResolvedIconUrl(Icon.Delete))); //// 在第一行新增一条数据 //btnNew2.OnClientClick = Grid2.GetAddNewRecordReference(defaultObj2, AppendToEnd); //// 删除选中行按钮 //btnDelete2.OnClientClick = Grid2.GetNoSelectionAlertReference("请至少选择一项!") + deleteScript2; if (Request.QueryString["id"] != null) { sGuid = Request.QueryString["id"].ToString().Trim(); LoadData(sGuid); BindGrid(); } //BindGrid(); } }
private string checkInput() { string msg = ""; //if (txt_qymc.Text.Trim() == "") msg += "请输入企业名称!"; //if (drp_sd.SelectedValue.ToString() == "3304") msg += "请选择企业所属区域!"; //if (drop_status.SelectedValue.ToString() == "0") msg += "请选择企业生产状态!"; //if (drop_industry.SelectedValue.ToString() == "0") msg += "请选择企业所属行业!"; //if (sGuid == string.Empty || sGuid == null) //{ // string checkstr = "select * from Enterprise where Name='" + txt_qymc.Text.Trim() + "'"; // DataSet dscheck = new MyDataOp().CreateDataSet(checkstr); // if (dscheck != null) // if (dscheck.Tables[0].Rows.Count > 0) // { // msg += "该企业已存在!"; // } //} //else //{ // string checkstr = "select * from Enterprise where Name='" + txt_qymc.Text.Trim() + "' and EnterpriseID!='" + sGuid + "'"; // DataSet dscheck = new MyDataOp().CreateDataSet(checkstr); // if (dscheck != null) // if (dscheck.Tables[0].Rows.Count > 0) // { // msg += "单位全称不能重复!"; // } //} int RID = DAL.User.GetUserID(txt_HandleMan.Text.Trim(), 4); if (RID == 0) { msg += "请选择正确的处置人!"; } else { hf_HandelManID.Text = RID.ToString(); } if (!string.IsNullOrEmpty(txt_Receiver.Text.Trim())) { int RID2 = DAL.User.GetUserID(txt_Receiver.Text.Trim(), 2); if (RID2 == 0) { msg += "请选择正确的签收人!"; } else { hf_ReceiverID.Text = RID2.ToString(); } } decimal PlanAmount = decimal.Parse(NB_Amount.Text.Trim()); decimal Old = 0; if (!string.IsNullOrEmpty(sGuid)) { Entity.WasteToProduct ws = DAL.WasteToProduct.GetWasteToProduct(int.Parse(sGuid)); Old = ws.FromAmount; } 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) { msg += "罐池的剩余量不足,罐池的剩余量为" + (capacity - used).ToString() + "!"; } #region 判断是否有重复项,暂时去掉 //判断是否有重复项 List <string> All3 = new List <string>(); Hashtable ht3 = new Hashtable(); Dictionary <int, Dictionary <string, object> > modifiedDict3 = Grid1.GetModifiedDict(); foreach (int rowIndex in modifiedDict3.Keys) { All3.Add(Grid1.DataKeys[rowIndex][1].ToString()); } List <Dictionary <string, object> > newAddedList3 = Grid1.GetNewAddedList(); for (int i = 0; i < newAddedList3.Count; i++) { All3.Add(newAddedList3[i]["WasteName"].ToString()); } List <int> deletedRows3 = Grid1.GetDeletedList(); foreach (int rowIndex in deletedRows3) { All3.Remove(Grid1.DataKeys[rowIndex][1].ToString()); } for (int i = 0; i < All3.Count; i++) { if (ht3.ContainsKey(All3[i])) { ht3[All3[i]] = int.Parse(ht3[All3[i]].ToString()) + 1; } else { ht3.Add(All3[i], 1); } } IDictionaryEnumerator ie3 = ht3.GetEnumerator(); while (ie3.MoveNext()) { if (int.Parse(ie3.Value.ToString()) > 1) { msg += "成品中出现重复项" + ie3.Key + "!"; } //Console.WriteLine(ie.Key.ToString() + "记录条数:" + ie.Value); } #endregion #region 判断是否有重复的罐池,并判断污染物和罐池是否对应 List <string> All = new List <string>(); Hashtable ht = new Hashtable(); Dictionary <int, Dictionary <string, object> > modifiedDict = Grid1.GetModifiedDict(); foreach (int rowIndex in modifiedDict.Keys) { All.Add(Grid1.DataKeys[rowIndex][3].ToString()); Entity.Pond ponda = DAL.Pond.GetPondByName(Grid1.DataKeys[rowIndex][3].ToString()); if (Grid1.DataKeys[rowIndex][1].ToString() != ponda.WasteName) { msg += Grid1.DataKeys[rowIndex][1].ToString() + "不能存入" + Grid1.DataKeys[rowIndex][3].ToString() + "!"; } } List <Dictionary <string, object> > newAddedList = Grid1.GetNewAddedList(); for (int i = 0; i < newAddedList.Count; i++) { All.Add(newAddedList[i]["Name"].ToString()); Entity.Pond ponda = DAL.Pond.GetPondByName(newAddedList[i]["Name"].ToString()); if (newAddedList[i]["WasteName"].ToString() != ponda.WasteName) { msg += newAddedList[i]["WasteName"].ToString() + "不能存入" + newAddedList[i]["Name"].ToString() + "!"; } } List <int> deletedRows = Grid1.GetDeletedList(); foreach (int rowIndex in deletedRows) { All.Remove(Grid1.DataKeys[rowIndex][3].ToString()); } for (int i = 0; i < All.Count; i++) { if (ht.ContainsKey(All[i])) { ht[All[i]] = int.Parse(ht[All[i]].ToString()) + 1; } else { ht.Add(All[i], 1); } } IDictionaryEnumerator ie = ht.GetEnumerator(); while (ie.MoveNext()) { if (int.Parse(ie.Value.ToString()) > 1) { msg += "成品中出现重复罐池" + ie.Key.ToString() + "!"; } //Console.WriteLine(ie.Key.ToString() + "记录条数:" + ie.Value); } #endregion #region 判断危废是否重复 //判断是否有重复项 //List<string> All2 = new List<string>(); //Hashtable ht2 = new Hashtable(); //Dictionary<int, Dictionary<string, object>> modifiedDict2 = Grid2.GetModifiedDict(); //foreach (int rowIndex in modifiedDict2.Keys) //{ // All2.Add(Grid2.DataKeys[rowIndex][1].ToString()); //} //List<Dictionary<string, object>> newAddedList2 = Grid2.GetNewAddedList(); //for (int i = 0; i < newAddedList2.Count; i++) //{ // All2.Add(newAddedList2[i]["WasteName2"].ToString()); //} //List<int> deletedRows2 = Grid2.GetDeletedList(); //foreach (int rowIndex in deletedRows2) //{ // All2.Remove(Grid2.DataKeys[rowIndex][1].ToString()); //} //for (int i = 0; i < All2.Count; i++) //{ // if (ht2.ContainsKey(All2[i])) // { // ht2[All2[i]] = int.Parse(ht2[All2[i]].ToString()) + 1; // } // else // { // ht2.Add(All2[i], 1); // } //} //IDictionaryEnumerator ie2 = ht2.GetEnumerator(); //while (ie2.MoveNext()) //{ // if (int.Parse(ie2.Value.ToString()) > 1) // { // msg += "危废中出现重复项"+ie2.Key+"!"; // } // //Console.WriteLine(ie.Key.ToString() + "记录条数:" + ie.Value); //} #endregion return(msg); }
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 DealID = int.Parse(HttpUtility.UrlEncode(keys[0].ToString())); Entity.WasteToProduct entity = DAL.WasteToProduct.GetWasteToProduct(DealID); if (entity.Status == 2) { Alert.ShowInTop("该记录已经审核通过了!", MessageBoxIcon.Warning); return; } entity.CreateDate = DateTime.Now; entity.CreateUser = Request.Cookies["Cookies"].Values["UserName"].ToString(); entity.UpdateDate = DateTime.Now; entity.UpdateUser = Request.Cookies["Cookies"].Values["UserName"].ToString(); entity.Status = 2; //先判断是否可行 int PondID = entity.FromPondID; Entity.Pond pond2 = DAL.Pond.GetPond(PondID); //decimal Used = DAL.PondUsed.GetPondUsedAmount(PondID); decimal Used = pond2.Used; decimal Now = Used - entity.FromAmount; if (Now < 0) { string message = "出库罐池" + pond2.Name + "库存不足!"; Alert.ShowInTop(message, MessageBoxIcon.Warning); return; } List <Entity.ProductDetail> lists = DAL.ProductDetail.GetProductDetailEx(DealID); bool IsOK = true; foreach (Entity.ProductDetail list in lists) { int PondID2 = list.PondID; Entity.Pond pond = DAL.Pond.GetPond(PondID2); decimal Capacity = pond.Capacity; //decimal Used2 = DAL.PondUsed.GetPondUsedAmount(PondID2); decimal Used2 = pond.Used; decimal Now2 = Used2 + list.Amount; if (Capacity < Now2) { string message = "入库罐池" + pond.Name + "余量不足!"; IsOK = false; Alert.ShowInTop(message, MessageBoxIcon.Warning); return; } list.Amount = Now2; } if (IsOK == false) { return; } int BSuccess = DAL.WasteToProduct.PassWasteToProduct(entity, Now, lists); if (BSuccess == 1) { Alert.ShowInTop(" 操作成功!", MessageBoxIcon.Information); BindGrid(); } else { Alert.ShowInTop(" 操作失败!", MessageBoxIcon.Warning); } }