private int Save(ClAgreementPercent cl) { if (cl.unitNumberNazer == Convert.ToDecimal(0) || cl.unitNumberNazer == null) { return(-66); } int i = 0; if (cl.utilityPersent.ToString() == "0.0") { return(-100); } if (cl.AgreementPercentID == null || cl.AgreementPercentID == 0) { i = AgreementPercentClass.insert(cl); } else { i = AgreementPercentClass.Update(cl); } return(i); }
public string AgreePercent_Save(string AgreementPercentID, string AgreementID, string ExplainID, string utilityPersent, string SuperVisorID, string VisitDate, string FineFactor, string JarimeComment, string FineMeterOrRepeat) { try { ClAgreementPercent cl = new ClAgreementPercent(); cl.AgreementID = Convert.ToInt32(AgreementID); cl.AgreementPercentID = Convert.ToInt32(AgreementPercentID); cl.ExplainID = Convert.ToInt32(ExplainID); cl.FineFactor = FineFactor; cl.FineMeterOrRepeat = Convert.ToInt32(FineMeterOrRepeat); cl.JarimeComment = JarimeComment; cl.SuperVisorID = Convert.ToInt32(SuperVisorID); cl.utilityPersent = Convert.ToInt32(utilityPersent); cl.VisitDate = DateConvert.sh2m(VisitDate).ToString(); int t = 0; if (AgreementPercentID == null || AgreementPercentID == "0" || AgreementPercentID == "") { t = AgreementPercentClass.insert(cl); } else { t = AgreementPercentClass.Update(cl); } return(t.ToString()); } catch { return("0"); } }
protected void BtnSerach_Click(object sender, EventArgs e) { DataSet ds = AgreementPercentClass.GetList(Data); GridView1.DataSource = ds; GridView1.DataBind(); LightBox.Value = "0"; }
public string AgreePercent_Delete(string AgreePercentID) { try { return(AgreementPercentClass.Delete(AgreePercentID).ToString()); } catch { return(null); } }
public string AgreePercent_Get(int AgreeID, string VisitDate) { try { ClAgreementPercent cl = new ClAgreementPercent(); cl.AgreementID = AgreeID; cl.VisitDate = DateConvert.sh2m(VisitDate).ToString(); DataSet ds = AgreementPercentClass.GetList(cl); return(ds.GetXml()); } catch { return(null); } }
public void BindGrid() { try { ClAgreementPercent cl = new ClAgreementPercent(); cl.AgreementID = Convert.ToInt32(lblAgreement.Text); cl.VisitDate = DateConvert.sh2m(txtDate.Value).ToString(); cl.SubjectID = Convert.ToInt32(ddsubject.SelectedValue); if (cl.SubjectID == null) { BindSubject(); cl.SubjectID = 0; } if (cl.AgreementID == null) { Response.Redirect("~/Bazras/ALlPeyman.aspx"); } if (cl.AgreementID == null || cl.VisitDate == null || cl.SubjectID == null) { return; } if (cl == null) { return; } DataSet ds = AgreementPercentClass.GetList2(cl); DataView dv = new DataView(ds.Tables[0]); if (ViewState["AgreementPercentID"] == null) { ViewState["AgreementPercentID"] = "AgreementPercentID Desc"; } dv.Sort = Securenamespace.SecureData.CheckSecurity(ViewState["AgreementPercentID"].ToString()).ToString(); GridView1.DataSource = dv; GridView1.DataBind(); RowColor(); ds.Dispose(); } catch { } }
public void ViewPercentItem(object sender, EventArgs e) { String AgreementID = ((HtmlAnchor)sender).Attributes["AgreementID"].ToString() == "" ? Agreeid.ToString() : ((HtmlAnchor)sender).Attributes["AgreementID"].ToString(); String ExpanlID = ((HtmlAnchor)sender).Attributes["ExplainID"].ToString(); ClAgreementPercent cl = new ClAgreementPercent(); cl.AgreementID = Convert.ToInt32(AgreementID); cl.ExplainID = Convert.ToInt32(ExpanlID); cl.VisitDate = DateConvert.sh2m(txtDate.Value).ToString(); DataSet ds = AgreementPercentClass.GetList_inmonth(cl); GridAllPercent.DataSource = ds; GridAllPercent.DataBind(); LightBox4.Value = "1"; }
public void DeleteItem(object sender, System.EventArgs e) { String AgreementFineID = ((HtmlAnchor)sender).HRef.ToString(); int i = AgreementPercentClass.Delete(AgreementFineID); if (i == 0) { LblMsg.Text = " error "; ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('خطا در حذف');", true); } else { BindGrid(); } LightBox.Value = "0"; }
public void BindGrid() { DateTime sd = DateTime.Now; DateTime ed; try { ClAgreementPercent cl = new ClAgreementPercent(); cl.AgreementID = Convert.ToInt32(AgreementID); cl.ExplainID = DDExplainID.SelectedValue; cl.VisitDate = DateConvert.sh2m(txtdatetimenow.Text).ToString(); DataSet ds = AgreementPercentClass.GetList_inmonth(cl); DataView dv = new DataView(ds.Tables[0]); if (ViewState["AgreementPercentID"] == null) { ViewState["AgreementPercentID"] = "AgreementPercentID Desc"; } dv.Sort = Securenamespace.SecureData.CheckSecurity(ViewState["AgreementPercentID"].ToString()).ToString(); GridView1.DataSource = dv; GridView1.DataBind(); txtunitNumberNazer.Text = unitNumberDEfault(Convert.ToInt32(AgreementID), Convert.ToInt32(DDExplainID.SelectedValue)).ToString(); LBLunitNumberNazer.Text = unitNumberDEfault(Convert.ToInt32(AgreementID), Convert.ToInt32(DDExplainID.SelectedValue)).ToString(); RowColor(); ds.Dispose(); } catch (Exception ex) { ed = DateTime.Now; var lineNumber = new System.Diagnostics.StackTrace(ex, true).GetFrame(0).GetFileLineNumber(); clError cl = new clError(); cl.ErrorLog = ex.Message.ToString(); cl.Page = HttpContext.Current.Request.Url.OriginalString; cl.timeLeft = (ed - sd).TotalSeconds.ToString(); cl.IP = CSharp.PublicFunction.GetIPAddress(); ErrorDAL.insert(cl); } }
private int Savepaymankar(ClAgreementPercent cl) { if (cl.UnitNumberPeymankar == Convert.ToDecimal(0) || cl.UnitNumberPeymankar == null) { return(-66); } int i = 0; if (cl.agreementpeymankarid == null || cl.agreementpeymankarid == 0) { i = AgreementPercentClass.insertpishnehadpeymankar(cl); } else { i = AgreementPercentClass.Updatepishnehadpeymankar(cl); } return(i); }
protected void BtnInsert_Click(Object sender, System.EventArgs e) { if (Convert.ToDecimal(TXTutilityPersent.Text) > 100 || Convert.ToDecimal(TXTutilityPersent.Text) < 0) { CSharp.Utility.ShowMsg(Page, CSharp.ProPertyData.MsgType.warning, "درصد وارده باید از 100 کوچکتر باشد"); return; } if (Convert.ToDecimal(txtunitNumberNazer.Text) > Convert.ToDecimal(LBLunitNumberNazer.Text) && lblRotinOrNott.Text == "1") { CSharp.Utility.ShowMsg(Page, CSharp.ProPertyData.MsgType.warning, "متراژ نباید از " + LBLunitNumberNazer.Text.ToString() + " بیشتر باشد. "); return; } ClAgreementPercent cl = new ClAgreementPercent(); cl = Data; int t = 0; if (CSharp.PublicFunction.ModeInsert(LblParamAgreementPercentID.Text)) { t = AgreementPercentClass.insert(cl); } else { t = AgreementPercentClass.Update(cl); } if (t == 0) { LblMsg.ForeColor = System.Drawing.Color.Red; LblMsg.Text = "خطا در ثبت"; } else if (t == -1) { CSharp.Utility.ShowMsg(Page, CSharp.ProPertyData.MsgType.warning, "سقف ثبت بازدید تکمیل شده است"); } else if (t == -2) { CSharp.Utility.ShowMsg(Page, CSharp.ProPertyData.MsgType.warning, "برای این شرح کار در این تاریخ درصد ثبت شده است"); } else if (t == -3) { CSharp.Utility.ShowMsg(Page, CSharp.ProPertyData.MsgType.warning, "فقط ناظر مقیم و مدیر سیستم میتوانند درصد وارد نمایند"); } else if (t == -4) { CSharp.Utility.ShowMsg(Page, CSharp.ProPertyData.MsgType.warning, "تا 48 ساعت قبل شما مجاز به ورود درصد هستید"); } else if (t == -10) { CSharp.Utility.ShowMsg(Page, CSharp.ProPertyData.MsgType.warning, "بیشتر از 10 درصد نمیتوان ویرایش کرد"); } else if (t == -11 || t == -12 || t == -13 || t == -14 || t == -15 || t == -16) { CSharp.Utility.ShowMsg(Page, CSharp.ProPertyData.MsgType.warning, "بازه زمانی تغییر به اتمام رسیده است"); } else { LblMsg.ForeColor = System.Drawing.Color.Green; LblMsg.Text = "ثبت انجام شد."; BindGrid(); } LightBox.Value = "0"; LblParamAgreementPercentID.Text = "0"; }