public void BindGrid() { ClAgreementFine cl = new ClAgreementFine(); if (NotDefaultAgree == false) { cl.AgreementID = 0; } else { cl.AgreementID = Convert.ToInt32(AgreementID); } DataSet ds = AgreementFineClass.GetList(cl); DataView dv = new DataView(ds.Tables[0]); if (ViewState["AgreementFineID"] == null) { ViewState["AgreementFineID"] = "AgreementFineID Desc"; } dv.Sort = Securenamespace.SecureData.CheckSecurity(ViewState["AgreementFineID"].ToString()).ToString(); GridView1.DataSource = dv; GridView1.DataBind(); }
public void UpItem(object sender, EventArgs e) { String AgreementFineID = ((HtmlAnchor)sender).HRef.ToString(); LblParamAgreementFineID.Text = AgreementFineID; ClAgreementFine cl = new ClAgreementFine(); cl.AgreementFineID = Convert.ToInt32(AgreementFineID); Data = cl; LightBox.Value = "1"; }
protected void btnprint21_Click(object sender, EventArgs e) { try { DataSet ds = null; if (Request.QueryString["RName"].ToString() == "Rp_ExplainPrice2" || Request.QueryString["RName"].ToString() == "Rp_SubjectPrice" ) { ClArchiveAgree cl = new ClArchiveAgree(); cl.AgreeID = Convert.ToInt32(ddAgree.SelectedValue); cl.AcrchiveID = ctlArchiveDD.SelectedValue; if (Request.QueryString["RName"].ToString() == "Rp_ExplainPrice2") { ds = ArchiveAgreeClass.GetListReport(cl); } else if (Request.QueryString["RName"].ToString() == "Rp_SubjectPrice") { ds = AgreementClass.GetListSubjectPrice(cl); } } else if (Request.QueryString["RName"].ToString() == "SumPay" || Request.QueryString["RName"].ToString() == "SumPay2" || Request.QueryString["RName"].ToString() == "RptSumPayPage") { ClExplanSubject cl2 = new ClExplanSubject(); cl2.ExplainSubjectID = Convert.ToInt32(CtlAllSubjectExplan.SelectedValue); cl2.SubjectID = Convert.ToInt32(CtlAllSubjectExplan.subjectID); cl2.FromDate = CtlFromToDate.FromDate; cl2.ToDate = CtlFromToDate.ToDate; ds = ExplanSubjectClass.GetListSumPay(cl2, 0); } else if (Request.QueryString["RName"].ToString() == "Rp_Khesarat" || Request.QueryString["RName"].ToString() == "rp_khesart3") { ClAgreementFine cl = new ClAgreementFine(); cl.AgreementID = Convert.ToInt32(ddAgree.SelectedValue); cl.ArchivID = Convert.ToInt32(ctlArchiveDD.SelectedValue); ds = AgreementFineClass.GetList_Rep(cl); } Session["ReportData"] = ds; MyIfarm1.Visible = true; MyIfarm1.Attributes.Add("src", "~/Report/reportview2.aspx?RName=" + Request.QueryString["RName"].ToString() + "&PName=" + Request.QueryString["PName"].ToString()); } catch { } }
//--------------------------------------------------------------------------------------------------------- public static DataSet GetList_Rep(ClAgreementFine c) { SqlCommand cmd = new SqlCommand("PRC_AgreementFine_GetList_rep", cnn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("UserIDLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetUserID(); cmd.Parameters.Add(new SqlParameter("IpLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetIPAddress(); cmd.Parameters.Add(new SqlParameter("OSLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetOS(); cmd.Parameters.Add(new SqlParameter("OSVerLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetBrowser() + CSharp.PublicFunction.GetBrowserVersion(); cmd.Parameters.Add(new SqlParameter("URLLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetURL(); cmd.Parameters.Add(new SqlParameter("AgreementFineID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.AgreementFineID); cmd.Parameters.Add(new SqlParameter("FineID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.FineID); cmd.Parameters.Add(new SqlParameter("AgreementID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.AgreementID); cmd.Parameters.Add(new SqlParameter("FineDate", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.FineDate); cmd.Parameters.Add(new SqlParameter("FinePrice", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.FinePrice); cmd.Parameters.Add(new SqlParameter("FineComment", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.FineComment); cmd.Parameters.Add(new SqlParameter("ArchivID", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.ArchivID); SqlParameter prmResult = new SqlParameter("Result", SqlDbType.Int); prmResult.Direction = ParameterDirection.Output; cmd.Parameters.Add(prmResult); DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(cmd); try { cnn.Open(); da.Fill(ds); return(ds); } catch (Exception ex) { return(null); } finally { cnn.Close(); } }
public static int insert(ClAgreementFine c) { SqlCommand cmd = new SqlCommand("PRC_AgreementFine_Insert", cnn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("UserIDLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetUserID(); cmd.Parameters.Add(new SqlParameter("IpLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetIPAddress(); cmd.Parameters.Add(new SqlParameter("OSLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetOS(); cmd.Parameters.Add(new SqlParameter("OSVerLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetBrowser() + CSharp.PublicFunction.GetBrowserVersion(); cmd.Parameters.Add(new SqlParameter("URLLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetURL(); cmd.Parameters.Add(new SqlParameter("FineID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.FineID); cmd.Parameters.Add(new SqlParameter("AgreementID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.AgreementID); cmd.Parameters.Add(new SqlParameter("FineDate", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.FineDate); cmd.Parameters.Add(new SqlParameter("FinePrice", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.FinePrice); cmd.Parameters.Add(new SqlParameter("FineComment", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.FineComment); cmd.Parameters.Add(new SqlParameter("NumberFine", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.NumberFine); cmd.Parameters.Add(new SqlParameter("AdressFine", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.AdressFine); SqlParameter prmResult = new SqlParameter("Result", SqlDbType.Int); prmResult.Direction = ParameterDirection.Output; cmd.Parameters.Add(prmResult); try { cnn.Open(); cmd.ExecuteNonQuery(); return(Convert.ToInt32(prmResult.Value)); } catch (Exception ex) { return(0); } finally { cnn.Close(); } }
protected void BtnInsert_Click(Object sender, System.EventArgs e) { //if (TXTFineDate.Text == "") // return; if (txtAdressFine.Text == "" || TXTFineComment.Text == "" || DDFineID.Text == "" || TXTFineDate.Text == "" || TXTFinePrice.Text == "" || txtNumberFine.Text == "") { LblMsg.ForeColor = System.Drawing.Color.Red; LblMsg.Text = "تمام اطلاعات باید وارد شوند"; return; } ClAgreementFine cl = new ClAgreementFine(); cl = Data; int t = 0; if (CSharp.PublicFunction.ModeInsert(AgreementFineID.ToString())) { t = AgreementFineClass.insert(cl); } else { t = AgreementFineClass.Update(cl); } if (t == 0) { LblMsg.ForeColor = System.Drawing.Color.Red; LblMsg.Text = "خطا در ثبت"; } else { LblMsg.ForeColor = System.Drawing.Color.Green; LblMsg.Text = "ثبت انجام شد."; BindGrid(); } LightBox.Value = "0"; LblParamAgreementFineID.Text = "0"; }