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);
}
