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