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