public string SubjectExpaln()
{
ClExplanSubject cl = new ClExplanSubject();
DataSet ds = ExplanSubjectClass.GetList(cl);
return(ds.GetXml());
}
public void UseFromKolItem(object sender, EventArgs e)
{
String ExplainSubjectID = ((HtmlAnchor)sender).HRef.ToString();
String UseFromKol = ((HtmlAnchor)sender).Attributes["UseFromKol"].ToString();
if (UseFromKol == "0")
{
UseFromKol = "1";
}
else
{
UseFromKol = "0";
}
ClExplanSubject cl = new ClExplanSubject();
cl.ExplainSubjectID = Convert.ToInt32(ExplainSubjectID);
cl.UseFromKol = Convert.ToInt32(UseFromKol);
if (ExplanSubjectClass.Update(cl) == 0)
{
CSharp.Utility.ShowMsg(Page, CSharp.ProPertyData.MsgType.warning, "خطا در ثیت");
}
else
{
BindGrid();
}
}
protected void BtnInsert_Click(Object sender, System.EventArgs e)
{
ClExplanSubject cl = new ClExplanSubject();
cl = Data;
int t = 0;
if (CSharp.PublicFunction.ModeInsert(ExplainSubjectID.ToString()))
{
t = ExplanSubjectClass.insert(cl);
}
else
{
t = ExplanSubjectClass.Update(cl);
}
if (t == 0)
{
LblMsg.ForeColor = System.Drawing.Color.Red;
LblMsg.Text = "خطا در ثبت";
}
else if (t == -1)
{
CSharp.Utility.ShowMsg(Page, CSharp.ProPertyData.MsgType.warning, "خطا در ثبت مجدد شرح کار!!!");
}
else
{
LblMsg.ForeColor = System.Drawing.Color.Green;
LblMsg.Text = "ثبت انجام شد.";
BindGrid();
}
LightBox.Value = "0";
LblParamExplainSubjectID.Text = "0";
}
public void VisibleItem(object sender, System.EventArgs e)
{
String ExplanID = ((HtmlAnchor)sender).HRef.ToString();
String VisibleItem = ((HtmlAnchor)sender).Attributes["VisibleItem"].ToString();
if (VisibleItem == "0")
{
VisibleItem = "1";
}
else
{
VisibleItem = "0";
}
ClExplanSubject cl = new ClExplanSubject();
cl.ExplainSubjectID = Convert.ToInt32(ExplanID);
cl.Visible = Convert.ToInt32(VisibleItem);
if (ExplanSubjectClass.Update(cl) == 0)
{
CSharp.Utility.ShowMsg(Page, CSharp.ProPertyData.MsgType.warning, "خطا در ثیت");
}
else
{
BindGrid();
}
}
private void BindExplan()
{
if (ddSubject.Items.Count == 0)
{
CSharp.Utility.ShowMsg(Page, CSharp.ProPertyData.MsgType.warning, "شرح کاری برای ورود فعال نشده است");
return;
}
ClExplanSubject cl = new ClExplanSubject();
cl.SubjectID = Convert.ToInt32(ddSubject.SelectedValue);
cl.AgreeMentID = Convert.ToInt32(lblAgreementID.Text);
cl.OnlyActive = Convert.ToInt32(lblOnlyActiveView.Text);
DataSet dss = ExplanSubjectClass.GetList(cl);
DDExplan.DataSource = dss;
DDExplan.DataTextField = "ExplainName";
DDExplan.DataValueField = "ExplainSubjectID";
// lblunitnumberkol.Text = dss.Tables[0].Rows[0]["unitnumberkol"].ToString();
DDExplan.DataBind();
// if (DDExplan.Items.Count > 0)
// DDExplan.Items.Add("همه موارد");
if (E_ExpalnChange != null)
{
try
{
E_ExpalnChange();
}
catch { }
}
}
protected void BtnSerach_Click(object sender, EventArgs e)
{
DataSet ds = ExplanSubjectClass.GetList(Data);
GridView1.DataSource = ds;
GridView1.DataBind();
LightBox.Value = "0";
}
private void BindExplainSubject()
{
ClExplanSubject cl2 = new ClExplanSubject();
cl2.SubjectID = Convert.ToInt32(ddSubject.SelectedValue);
DDSubjectExplainID.DataSource = ExplanSubjectClass.GetList(cl2);
DDSubjectExplainID.DataTextField = "ExplainName";
DDSubjectExplainID.DataValueField = "ExplainSubjectID";
DDSubjectExplainID.DataBind();
DDSubjectExplainID.Items.Insert(0, new ListItem(" استفاده از کل ", "-1"));
}
private void BindExpaln()
{
ClExplanSubject cl = new ClExplanSubject();
cl.SubjectID = Convert.ToInt32(ddSubject.SelectedValue);
ddexplan.DataSource = ExplanSubjectClass.GetList(cl);
ddexplan.DataTextField = "ExplainName";
ddexplan.DataValueField = "ExplainSubjectID";
ddexplan.DataBind();
if (BindAll == "1")
{
ddexplan.Items.Insert(0, new ListItem("همه موارد", "0"));
}
}
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 BindGrid()
{
ClExplanSubject cl = new ClExplanSubject();
cl.SubjectID = Convert.ToInt32(DDSubjectID.SelectedValue);
DataSet ds = ExplanSubjectClass.GetList(cl);
DataView dv = new DataView(ds.Tables[0]);
if (ViewState["ExplainSubjectID"] == null)
{
ViewState["ExplainSubjectID"] = "ExplainSubjectID Desc";
}
dv.Sort = Securenamespace.SecureData.CheckSecurity(ViewState["ExplainSubjectID"].ToString()).ToString();
GridView1.DataSource = dv;
GridView1.DataBind();
}
public void DeleteItem(object sender, System.EventArgs e)
{
String ParkID = ((HtmlAnchor)sender).HRef.ToString();
int i = ExplanSubjectClass.Delete(ParkID);
if (i == 0)
{
LblMsg.Text = " error ";
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('خطا در حذف');", true);
}
else
{
BindGrid();
}
LightBox.Value = "0";
}
private string GetSubjectID(int explanid)
{
ClExplanSubject cl = new ClExplanSubject();
cl.ExplainSubjectID = explanid;
DataSet ds = ExplanSubjectClass.GetList(cl);
if (ds.Tables[0].Rows.Count > 0)
{
return(ds.Tables[0].Rows[0]["SubjectID"].ToString());
}
else
{
return("0");
}
}
private string unitNumberDEfault(int agreeid, int explanid)
{
string o = "0";
ClExplanSubject cl = new ClExplanSubject();
cl.AgreeMentID = agreeid;
cl.ExplainSubjectID = explanid;
cl.SubjectID = Convert.ToInt32(DDExplainID.SubjectID == "" ?"0":DDExplainID.SubjectID);
DataSet ds = ExplanSubjectClass.GetListUnitNumberAgreeExpal(cl);
if (ds.Tables[0].Rows.Count > 0)
{
o = ds.Tables[0].Rows[0]["unitnumberkol"].ToString();
}
else
{
o = "0";
}
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["RotinOrNot"].ToString() == "1")
{
lblRotinOrNott.Text = "1";
}
// txtunitNumberNazer.Enabled = false;
else
{
lblRotinOrNott.Text = "0";
}
// txtunitNumberNazer.Enabled = true;
}
ds.Dispose();
return(o);
}
