public static int PassWasteStorage(Entity.WasteStorage entity, decimal Used) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); SqlTransactionHelper thelper = new SqlTransactionHelper(DAL.Config.con); IDbTransaction trans = thelper.StartTransaction(); try { iReturn = db.ExecuteNonQueryTrans(trans, CommandType.Text, "Update [WasteStorage] set UpdateDate='"+ entity.UpdateDate + "',UpdateUser='******',Status='" + entity.Status + "'where StorageID='" + entity.StorageID + "'", null); iReturn = db.ExecuteNonQueryTrans(trans, CommandType.Text, "Insert into [PondUsed]([PondID],[Used],[SourceType],[TypeName],[CreateUser],[CreateDate]) values ('" + entity.PondID + "','" + Used + "','1','废酸入库','" + entity.CreateUser + "','" + entity.CreateDate + "')", null); iReturn = db.ExecuteNonQueryTrans(trans, CommandType.Text, "Update [Pond] set Used='"+ Used + "'where PondID='" + entity.PondID + "'", null); thelper.CommitTransaction(trans); iReturn = 1; } catch (Exception ex) { thelper.RollTransaction(trans); iReturn = 0; } finally { db.Conn.Close(); } return(iReturn); }
/// <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.WasteStorage entity = DAL.WasteStorage.GetWasteStorage(int.Parse(HttpUtility.UrlEncode(keys[0].ToString()))); if (entity.Status >= 2) { Alert.ShowInTop("审核通过的不能删除!", MessageBoxIcon.Information); return; } else { int BSuccess = DAL.WasteStorage.DeleteWasteStorage(int.Parse(HttpUtility.UrlEncode(keys[0].ToString()))); if (BSuccess == 1) { Alert.ShowInTop(" 操作成功!", MessageBoxIcon.Information); BindGrid(); } else { Alert.ShowInTop(" 操作失败!", MessageBoxIcon.Warning); } } }
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); } }
protected void btn_save_Click(object sender, EventArgs e) { string str = checkInfo(); if (str != "") { Alert.ShowInTop(str, MessageBoxIcon.Warning); } else { Entity.WasteStorage entity = new Entity.WasteStorage(); entity.PlanID = int.Parse(hf_PlanID.Text); entity.BillNumber = txt_BillNumber.Text.Trim(); entity.PlanNumber = tb_PlanNumber.Text.Trim(); entity.EnterpriseID = int.Parse(hf_EID.Text.Trim()); entity.DriverID = int.Parse(hf_DriverID.Text.Trim()); entity.CarID = int.Parse(hf_CarID.Text.Trim()); entity.PondID = int.Parse(drop_Pond.SelectedValue.ToString()); entity.ReceiverID = int.Parse(hf_ReceiverID.Text.Trim()); entity.WasteCode = hid_WasteCode.Text; entity.DateTime = Date_Start.SelectedDate; entity.Amount = 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.Status = 1; int iReturn = 0; if (sGuid == string.Empty || sGuid == null) { iReturn = DAL.WasteStorage.AddWasteStorage(entity); } else { entity.StorageID = int.Parse(sGuid); iReturn = DAL.WasteStorage.UpdateWasteStorage(entity); } if (iReturn == 1) { Alert.ShowInTop(" 保存成功!", MessageBoxIcon.Information); // PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); } else { Alert.ShowInTop(" 保存失败!", MessageBoxIcon.Warning); } } }
/// <summary> /// /// </summary> /// <param name="StorageID"> </param> /// <returns></returns> public static Entity.WasteStorage GetWasteStorage(int StorageID) { Entity.WasteStorage entity = null; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [vWasteStorage] where StorageID='" + StorageID + "'", null); while (dataReader.Read()) { entity = new Entity.WasteStorage(); entity.StorageID = DataHelper.ParseToInt(dataReader["StorageID"].ToString()); entity.PlanNumber = dataReader["PlanNumber"].ToString(); entity.PlanID = DataHelper.ParseToInt(dataReader["PlanID"].ToString()); entity.BillNumber = dataReader["BillNumber"].ToString(); entity.DateTime = DataHelper.ParseToDate(dataReader["DateTime"].ToString()); entity.EnterpriseID = DataHelper.ParseToInt(dataReader["EnterpriseID"].ToString()); entity.ProduceName = dataReader["ProduceName"].ToString(); entity.WasteCode = dataReader["WasteCode"].ToString(); entity.WasteName = dataReader["WasteName"].ToString(); entity.Amount = decimal.Parse(dataReader["Amount"].ToString()); entity.DriverID = DataHelper.ParseToInt(dataReader["DriverID"].ToString()); entity.RealName = dataReader["RealName"].ToString(); entity.CarID = DataHelper.ParseToInt(dataReader["CarID"].ToString()); entity.CarNumber = dataReader["CarNumber"].ToString(); entity.PondID = DataHelper.ParseToInt(dataReader["PondID"].ToString()); entity.PondName = dataReader["PondName"].ToString(); entity.ReceiverID = DataHelper.ParseToInt(dataReader["ReceiverID"].ToString()); entity.ReceiverName = dataReader["ReceiverName"].ToString(); //entity.CreateDate = DataHelper.ParseToDate(dataReader["CreateDate"].ToString()); //entity.CreateUser = dataReader["CreateUser"].ToString(); //entity.UpdateDate = DataHelper.ParseToDate(dataReader["UpdateDate"].ToString()); //entity.UpdateUser = dataReader["UpdateUser"].ToString(); entity.Status = DataHelper.ParseToInt(dataReader["Status"].ToString()); entity.StatusName = dataReader["StatusName"].ToString(); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(entity); }
public static int AddWasteStorage(Entity.WasteStorage 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("@PlanID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.PlanID.GetType().ToString()), entity.PlanID, 32), dbFactory.MakeInParam("@BillNumber", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.BillNumber.GetType().ToString()), entity.BillNumber, 20), dbFactory.MakeInParam("@DateTime", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.DateTime.GetType().ToString()), entity.DateTime, 0), dbFactory.MakeInParam("@EnterpriseID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.EnterpriseID.GetType().ToString()), entity.EnterpriseID, 32), dbFactory.MakeInParam("@WasteCode", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.WasteCode.GetType().ToString()), entity.WasteCode, 20), dbFactory.MakeInParam("@Amount", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Amount.GetType().ToString()), entity.Amount, 10), dbFactory.MakeInParam("@DriverID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.DriverID.GetType().ToString()), entity.DriverID, 32), dbFactory.MakeInParam("@PondID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.PondID.GetType().ToString()), entity.PondID, 32), dbFactory.MakeInParam("@ReceiverID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.ReceiverID.GetType().ToString()), entity.ReceiverID, 32), dbFactory.MakeInParam("@CreateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.CreateDate.GetType().ToString()), entity.CreateDate, 0), dbFactory.MakeInParam("@CreateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.CreateUser.GetType().ToString()), entity.CreateUser, 50), dbFactory.MakeInParam("@UpdateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UpdateDate.GetType().ToString()), entity.UpdateDate, 0), dbFactory.MakeInParam("@UpdateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UpdateUser.GetType().ToString()), entity.UpdateUser, 50), dbFactory.MakeInParam("@Status", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Status.GetType().ToString()), entity.Status, 32), dbFactory.MakeInParam("@CarID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.CarID.GetType().ToString()), entity.CarID, 32) }; iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_WasteStorage_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="DateTime"> </param> /// <returns></returns> public static List <Entity.WasteStorage> GetSumWasteStorage() { List <Entity.WasteStorage> list = new List <Entity.WasteStorage>(); DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { string Start = string.Format("{0}-01-01", DateTime.Now.Year); string End = string.Format("{0}-12-31", DateTime.Now.Year); IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "select sum(Amount) as Total,WasteName from vWasteStorage where Status>=2 and DateTime>='" + Start + "' and DateTime<='" + End + "' group by WasteName", null); while (dataReader.Read()) { Entity.WasteStorage entity = new Entity.WasteStorage(); //entity.StorageID = DataHelper.ParseToInt(dataReader["StorageID"].ToString()); //entity.PlanID = DataHelper.ParseToInt(dataReader["PlanID"].ToString()); //entity.BillNumber = dataReader["BillNumber"].ToString(); //entity.DateTime = DataHelper.ParseToDate(dataReader["DateTime"].ToString()); //entity.EnterpriseID = DataHelper.ParseToInt(dataReader["EnterpriseID"].ToString()); //entity.WasteCode = dataReader["WasteCode"].ToString(); entity.WasteName = dataReader["WasteName"].ToString(); entity.Amount = decimal.Parse(dataReader["Total"].ToString()); //entity.DriverID = DataHelper.ParseToInt(dataReader["DriverID"].ToString()); //entity.PondID = DataHelper.ParseToInt(dataReader["PondID"].ToString()); //entity.ReceiverID = DataHelper.ParseToInt(dataReader["ReceiverID"].ToString()); //entity.CreateDate = DataHelper.ParseToDate(dataReader["CreateDate"].ToString()); //entity.CreateUser = dataReader["CreateUser"].ToString(); //entity.UpdateDate = DataHelper.ParseToDate(dataReader["UpdateDate"].ToString()); //entity.UpdateUser = dataReader["UpdateUser"].ToString(); //entity.Status = DataHelper.ParseToInt(dataReader["Status"].ToString()); list.Add(entity); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(list); }
private void LoadData(string thisGuid) { if (thisGuid != string.Empty) { hf_StoreID.Text = thisGuid; Entity.WasteStorage entity = DAL.WasteStorage.GetWasteStorage(int.Parse(thisGuid)); txt_BillNumber.Text = entity.BillNumber; hf_PlanID.Text = entity.PlanID.ToString(); tb_PlanNumber.Text = entity.PlanNumber; txt_enterprise.Text = entity.ProduceName; hf_EID.Text = entity.EnterpriseID.ToString(); txt_Waste.Text = entity.WasteName; txt_CarNumber.Text = entity.CarNumber; hid_WasteCode.Text = entity.WasteCode; BindDropdownList(entity.WasteCode); drop_Pond.SelectedValue = entity.PondID.ToString(); Date_Start.SelectedDate = entity.DateTime; NB_Amount.Text = entity.Amount.ToString(); txt_Driver.Text = entity.RealName; hf_DriverID.Text = entity.DriverID.ToString(); txt_Receiver.Text = entity.ReceiverName; hf_ReceiverID.Text = entity.ReceiverID.ToString(); hf_CarID.Text = entity.CarID.ToString(); if (entity.Status >= 2) { //全部只读,而且不可保存 txt_BillNumber.Readonly = true; tb_PlanNumber.Readonly = true; txt_enterprise.Readonly = true; txt_Waste.Readonly = true; txt_CarNumber.Readonly = true; //BindDropdownList(entity.WasteCode); drop_Pond.Readonly = true; Date_Start.Readonly = true; NB_Amount.Readonly = true; txt_Driver.Readonly = true; txt_Receiver.Readonly = true; Grid1.Enabled = false; btn_save.Enabled = false; } } }
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); }