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