private void LoadData(string thisGuid)
{
if (thisGuid != string.Empty)
{
Entity.Contract entity = DAL.Contract.GetContract(int.Parse(thisGuid));
txt_ContractNumber.Text = entity.ContractNumber;
//entity.ProduceID = 1;
drop_handle.SelectedValue = entity.HandleID.ToString();
drop_Waste.SelectedValue = entity.WasteCode;
Date_Start.SelectedDate = entity.StartDate;
Date_End.SelectedDate = entity.EndDate;
Date_Sign.SelectedDate = entity.SignDate;
txt_Remark.Text = entity.Remark;
NB_Amount.Text = entity.Amount.ToString();
txt_Enterprise.Text = DAL.Enterprise.GetEnterpriseName(entity.ProduceID);
if (entity.StatusID == 2)
{
txt_ContractNumber.Readonly = true;
txt_Enterprise.Readonly = true;
drop_handle.Readonly = true;
drop_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_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 ContractID = int.Parse(HttpUtility.UrlEncode(keys[0].ToString()));
//Entity.Contract entity = new Entity.Contract();
//entity.ContractID = int.Parse(HttpUtility.UrlEncode(keys[0].ToString()));
Entity.Contract entity = DAL.Contract.GetContract(ContractID);
if (entity.StatusID == 2)
{
Alert.ShowInTop("该记录已经审核通过了！", MessageBoxIcon.Warning);
return;
}
entity.StatusID = 2;
entity.UpdateDate = DateTime.Now;
entity.UpdateUser = Request.Cookies["Cookies"].Values["UserName"].ToString();
int BSuccess = DAL.Contract.UpdateContractStatus(entity);
if (BSuccess == 1)
{
Alert.ShowInTop(" 操作成功！", MessageBoxIcon.Information);
BindGrid();
}
else
{
Alert.ShowInTop(" 操作失败！", MessageBoxIcon.Warning);
}
}
/// <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.Contract entity = DAL.Contract.GetContract(int.Parse(HttpUtility.UrlEncode(keys[0].ToString())));
if (entity.StatusID == 2)
{
Alert.ShowInTop("审核通过的不能删除！", MessageBoxIcon.Information);
return;
}
else
{
int BSuccess = DAL.Contract.DeleteContract(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.Contract entity = new Entity.Contract();
entity.ContractNumber = txt_ContractNumber.Text.Trim();
//int EID = DAL.Enterprise.GetEnterpriseID(txt_Enterprise.Text.Trim());
//entity.ProduceID = EID;
Entity.Enterprise enterprise = DAL.Enterprise.GetEnterpriseInfo(txt_Enterprise.Text.Trim());
entity.ProduceID = enterprise.EnterpriseID;
entity.ProduceArea = enterprise.AreaCode;
entity.HandleID = int.Parse(drop_handle.SelectedValue.Trim());
entity.WasteCode = drop_Waste.SelectedValue.Trim();
entity.StartDate = Date_Start.SelectedDate;
entity.EndDate = Date_End.SelectedDate;
entity.SignDate = Date_Sign.SelectedDate;
entity.Remark = txt_Remark.Text.Trim();
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.StatusID = 1;
entity.Total = 0;
int iReturn = 0;
if (sGuid == string.Empty || sGuid == null)
{
iReturn = DAL.Contract.AddContract(entity);
}
else
{
entity.ContractID = int.Parse(sGuid);
iReturn = DAL.Contract.UpdateContract(entity);
}
if (iReturn == 1)
{
Alert.ShowInTop(" 保存成功！", MessageBoxIcon.Information);
// PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference());
}
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.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);
}
}
}
protected void Grid1_RowDoubleClick(object sender, GridRowClickEventArgs e)
{
if (Grid1.SelectedRowIndex != -1)
{
object[] keys = Grid1.DataKeys[Grid1.SelectedRowIndex];
hid_htid.Text = keys[0].ToString();
txt_source.Text = keys[1].ToString();
Entity.Contract con = DAL.Contract.GetContract(int.Parse(keys[0].ToString()));
txt_Waste.Text = con.WasteName;
hid_WasteCode.Text = con.WasteCode;
Window_DepartQuery.Hidden = true;
Date_End.MaxDate = con.EndDate;
Date_Start.MinDate = con.StartDate;
//int Number = DAL.TransferPlan.GetMaxNumber(con.ProduceArea, DateTime.Now.Year) + 1;
//txt_PlanNumber.Text=GeneratePlanNumber(con.ProduceArea,DateTime.Now.Year,Number.ToString());
}
}
public int update(Entity.Contract entity)
{
return this.repository.update(entity);
}
public Entity.Contract insert(Entity.Contract entity)
{
return this.repository.insert(entity);
}
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);
}
