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();
}
}
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);
}
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 void DeleteItem(object sender, System.EventArgs e)
{
String AgreePercentProtestID = ((HtmlAnchor)sender).HRef.ToString();
int i = ArchiveAgreeClass.Delete(AgreePercentProtestID);
if (i == 0)
{
LblMsg.Text = " error ";
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('خطا در حذف');", true);
}
else
{
BindGrid();
}
}
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();
}
}
