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