private void BindGrid() { ClPeymanPark cl = new ClPeymanPark(); cl.AgreementID = Convert.ToInt32(ddagree.SelectedValue == "" ? "0":ddagree.SelectedValue); cl.PeymanID = Convert.ToInt32(ddPeyman.SelectedValue); cl.ExplanSubject = Convert.ToInt32(TXTExplanID.SelectedValue); if (cl == null) { return; } else if (cl.AgreementID == null || cl.PeymanID == null || cl.ExplanSubject == null) { return; } DataSet ds = PeymanParkClass.GetListpark(cl); Grid1.DataSource = ds; Grid1.DataBind(); lblsumkol.Text = SumKol(ds).ToString(); bindkhaki(); }
//--------------------------------------------------------------------------------------------------------- public static DataSet GetListpark(ClPeymanPark c) { SqlCommand cmd = new SqlCommand("PRC_PeymanPark_ExpalnSubject", cnn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("agreeid", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.AgreementID); cmd.Parameters.Add(new SqlParameter("ExplansubjectID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.ExplanSubject); cmd.Parameters.Add(new SqlParameter("peymanID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.PeymanID); 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 void UpItem(object sender, EventArgs e) { String PeymanParkID = ((HtmlAnchor)sender).HRef.ToString(); LblParamPeymanParkID.Text = PeymanParkID; ClPeymanPark cl = new ClPeymanPark(); cl.PeymanParkID = Convert.ToInt32(PeymanParkID); Data = cl; LightBox.Value = "1"; }
private void BindGrid() { ClPeymanPark cl = new ClPeymanPark(); cl.AgreementID = Convert.ToInt32(ddPeyman.SelectedValue); cl.PeymanID = Convert.ToInt32(ddPeyman2.SelectedValue); DataSet ds = PeymanParkClass.GetList(cl); Grid1.DataSource = ds; Grid1.DataBind(); // BindGridContetnt(); }
public void BindGrid() { ClPeymanPark cl = new ClPeymanPark(); cl.AgreementID = AgrrementID; DataSet ds = PeymanParkClass.GetList(cl); DataView dv = new DataView(ds.Tables[0]); if (ViewState["PeymanParkID"] == null) { ViewState["PeymanParkID"] = "PeymanParkID Desc"; } dv.Sort = Securenamespace.SecureData.CheckSecurity(ViewState["PeymanParkID"].ToString()).ToString(); GridView1.DataSource = dv; GridView1.DataBind(); }
public void BindGrid() { ClPeymanPark cl = new ClPeymanPark(); cl.AgreementID = AgrrementID; cl.PeymanID = Convert.ToInt32(DDPeymanID.SelectedValue); DataSet ds = PeymanParkClass.GetList(cl); DataView dv = new DataView(ds.Tables[0]); if (ViewState["PeymanParkID"] == null) { ViewState["PeymanParkID"] = "PeymanParkID Desc"; } dv.Sort = Securenamespace.SecureData.CheckSecurity(ViewState["PeymanParkID"].ToString()).ToString(); GridView1.DataSource = dv; GridView1.DataBind(); lblMetrajKol.Text = SumParks(ds); }
//--------------------------------------------------------------------------------------------------------- public static DataSet GetList(ClPeymanPark c) { SqlCommand cmd = new SqlCommand("PRC_PeymanPark_GetList", 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("PeymanParkID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.PeymanParkID); cmd.Parameters.Add(new SqlParameter("PeymanID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.PeymanID); cmd.Parameters.Add(new SqlParameter("ParkID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.ParkID); cmd.Parameters.Add(new SqlParameter("AgreementID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.AgreementID); 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(ClPeymanPark c) { SqlCommand cmd = new SqlCommand("PRC_PeymanPark_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("PeymanID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.PeymanID); cmd.Parameters.Add(new SqlParameter("ParkID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.ParkID); cmd.Parameters.Add(new SqlParameter("AgreementID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.AgreementID); 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) { ClPeymanPark cl = new ClPeymanPark(); cl = Data; int t = 0; if (CSharp.PublicFunction.ModeInsert(PeymanParkID.ToString())) { t = PeymanParkClass.insert(cl); } else { t = PeymanParkClass.Update(cl); } if (t == -1) { CSharp.Utility.ShowMsg(Page, CSharp.ProPertyData.MsgType.warning, "برای این پارک پیمان ثبت شده است"); } if (t == 0) { LblMsg.ForeColor = System.Drawing.Color.Red; LblMsg.Text = "خطا در ثبت"; } else { LblMsg.ForeColor = System.Drawing.Color.Green; LblMsg.Text = "ثبت انجام شد."; BindGrid(); } LblParamPeymanParkID.Text = "0"; }