public void BindGrid()
{
ClArchiveAgree cl = new ClArchiveAgree();
cl.AgreeID = Convert.ToInt32(lblAgrement.Text);
cl.SubjectID = Convert.ToInt32(ddSubject.SelectedValue);
cl.ArchiveTitleID = Convert.ToInt32(ArchivID);
DataSet ds = ArchiveAgreeClass.GetList(cl);
DataView dv = new DataView(ds.Tables[0]);
if (ViewState["AgreementID"] == null)
{
ViewState["AgreementID"] = "AgreeID Desc";
}
if (ViewState["AgreementID"] == null)
{
return;
}
dv.Sort = ViewState["AgreementID"].ToString();
GridView1.DataSource = dv;
GridView1.DataBind();
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
// LBLkHESARAT.Text = dr["finekhesarat"].ToString();
}
}
//---------------------------------------------------------------------------------------------------------
public static DataSet GetListSubjectPrice(ClArchiveAgree c)
{
SqlCommand cmd = new SqlCommand("PRC_Subject_ArchiveAgreeTitle_GetListReport", cnn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("AcrchiveID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.AcrchiveID);
cmd.Parameters.Add(new SqlParameter("AgreeID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.AgreeID);
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();
}
}
private int InsertArchiv(int iii)
{
ClArchiveAgree cl = new ClArchiveAgree();
cl.AgreeID = Convert.ToInt32(lblAgrement.Text);
cl.FromDate = DateConvert.sh2m(CtlFromDate.Text).ToString();
cl.ToDate = DateConvert.sh2m(CtlToDate.Text).ToString();
cl.ArchiveTitleID = iii;
int i = ArchiveAgreeClass.insert(cl);
if (i == -100)
{
CSharp.Utility.ShowMsg(Page, CSharp.ProPertyData.MsgType.warning, "خطا.در این بازه زمانی آرشیو صورت گرفته است");
}
else if (i == 0)
{
CSharp.Utility.ShowMsg(Page, CSharp.ProPertyData.MsgType.warning, "داده ای برای آرشیو وجود ندارد.خطا در ثبت آرشیو");
}
//ClExplanPrice cl = new ClExplanPrice();
//cl.AgreementID = AgreeID;
// DataSet ds = ExplanPriceClass.GetList(cl);
//DataRow dr;
//int result = 0;
//for(int i=0;i<ds.Tables[0].Rows.Count-1;i++){
// dr=ds.Tables[0].Rows[i];
// InsertOneSubject(Convert.ToInt32(dr["SubjectID"].ToString()));
// result += 1;
//}
return(i);
}
public void UpItem(object sender, EventArgs e)
{
String AreaID = ((HtmlAnchor)sender).HRef.ToString();
LblParamArchivID.Text = AreaID;
ClArchiveAgree cl = new ClArchiveAgree();
cl.AcrchiveID = Convert.ToInt32(AreaID);
Data = cl;
LightBox.Value = "1";
}
//---------------------------------------------------------------------------------------------------------
public static DataSet GetList(ClArchiveAgree c)
{
SqlCommand cmd = new SqlCommand("PRC_ArchiveAgree_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("AcrchiveID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.AcrchiveID);
cmd.Parameters.Add(new SqlParameter("AgreeID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.AgreeID);
cmd.Parameters.Add(new SqlParameter("SubjectID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.SubjectID);
cmd.Parameters.Add(new SqlParameter("SubjectExplainID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.SubjectExplainID);
cmd.Parameters.Add(new SqlParameter("UnitNameID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.UnitNameID);
cmd.Parameters.Add(new SqlParameter("PriceUnit", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.PriceUnit);
cmd.Parameters.Add(new SqlParameter("UtilityPercent", SqlDbType.NVarChar)).Value = c.UtilityPercent;
cmd.Parameters.Add(new SqlParameter("ActionPercent", SqlDbType.NVarChar)).Value = c.ActionPercent;
cmd.Parameters.Add(new SqlParameter("SumMeter", SqlDbType.NVarChar)).Value = c.SumMeter;
cmd.Parameters.Add(new SqlParameter("Pulus", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.Pulus);
cmd.Parameters.Add(new SqlParameter("OperationSum", SqlDbType.BigInt)).Value = Securenamespace.SecureData.CheckSecurity(c.OperationSum);
cmd.Parameters.Add(new SqlParameter("PaySum", SqlDbType.BigInt)).Value = Securenamespace.SecureData.CheckSecurity(c.PaySum);
cmd.Parameters.Add(new SqlParameter("FineZarib", SqlDbType.BigInt)).Value = Securenamespace.SecureData.CheckSecurity(c.FineZarib);
cmd.Parameters.Add(new SqlParameter("FromDate", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.FromDate);
cmd.Parameters.Add(new SqlParameter("ToDate", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.ToDate);
cmd.Parameters.Add(new SqlParameter("ArchiveTitleID", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.ArchiveTitleID);
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();
}
}
private int InsertOneSubject(int Subject)
{
ClArchiveAgree cl = new ClArchiveAgree();
cl.SubjectID = Subject;
cl.AgreeID = Convert.ToInt32(lblAgrement.Text);
cl.FromDate = DateConvert.sh2m(CtlFromDate.Text).ToString();
cl.ToDate = DateConvert.sh2m(CtlToDate.Text).ToString();
int i = ArchiveAgreeClass.insert(cl);
return(i);
}
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 int Update(ClArchiveAgree c)
{
SqlCommand cmd = new SqlCommand("PRC_ArchiveAgree_Update", 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("AcrchiveID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.AcrchiveID);
cmd.Parameters.Add(new SqlParameter("SubjectID", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.SubjectID);
cmd.Parameters.Add(new SqlParameter("SubjectExplainID", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.SubjectExplainID);
cmd.Parameters.Add(new SqlParameter("UnitNameID", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.UnitNameID);
cmd.Parameters.Add(new SqlParameter("PriceUnit", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.PriceUnit);
cmd.Parameters.Add(new SqlParameter("UtilityPercent", SqlDbType.NVarChar)).Value = c.UtilityPercent;
cmd.Parameters.Add(new SqlParameter("ActionPercent", SqlDbType.NVarChar)).Value = c.ActionPercent;
cmd.Parameters.Add(new SqlParameter("SumMeter", SqlDbType.NVarChar)).Value = c.SumMeter;
cmd.Parameters.Add(new SqlParameter("Pulus", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.Pulus);
cmd.Parameters.Add(new SqlParameter("OperationSum", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.OperationSum);
cmd.Parameters.Add(new SqlParameter("PaySum", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.PaySum);
cmd.Parameters.Add(new SqlParameter("FineZarib", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.FineZarib);
cmd.Parameters.Add(new SqlParameter("FromDate", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.FromDate);
cmd.Parameters.Add(new SqlParameter("ToDate", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.ToDate);
cmd.Parameters.Add(new SqlParameter("repeattt", SqlDbType.NVarChar)).Value = c.repeattt;
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, EventArgs e)
{
ClArchiveAgree cl = new ClArchiveAgree();
cl = Data;
int i = ArchiveAgreeClass.Update(cl);
if (i == 0)
{
CSharp.Utility.ShowMsg(Page, CSharp.ProPertyData.MsgType.warning, "خطا در ثبت");
}
else
{
BindGrid();
}
}
