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();
}
}
public string SubjectExpaln()
{
ClExplanSubject cl = new ClExplanSubject();
DataSet ds = ExplanSubjectClass.GetList(cl);
return(ds.GetXml());
}
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();
}
}
//---------------------------------------------------------------------------------------------------------
public static DataSet GetListSumPay(ClExplanSubject c, int PayOrMetraj = 0)
{
SqlCommand cmd = new SqlCommand("prc_diagramRep", cnn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("ExplainSubjectID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.ExplainSubjectID);
cmd.Parameters.Add(new SqlParameter("subjectID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.SubjectID);
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("PayOrMetraj", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(PayOrMetraj);
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 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 { }
}
}
public static DataSet GetListUnitNumberAgreeExpal(ClExplanSubject c)
{
SqlCommand cmd = new SqlCommand("PRC_ExplanSubject_unitsumAgreeExpalnDefault", cnn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("ExplainSubjectID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.ExplainSubjectID);
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 void UpItem(object sender, EventArgs e)
{
String ExplainSubjectID = ((HtmlAnchor)sender).HRef.ToString();
ClExplanSubject cl = new ClExplanSubject();
cl.ExplainSubjectID = Convert.ToInt32(ExplainSubjectID);
Data = cl;
LightBox.Value = "1";
}
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();
}
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");
}
}
//---------------------------------------------------------------------------------------------------------
public static DataSet GetList(ClExplanSubject c)
{
SqlCommand cmd = new SqlCommand("PRC_ExplanSubject_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("ExplainSubjectID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.ExplainSubjectID);
cmd.Parameters.Add(new SqlParameter("SubjectID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.SubjectID);
cmd.Parameters.Add(new SqlParameter("ExplainName", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.ExplainName);
cmd.Parameters.Add(new SqlParameter("DayPriceDefualt", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.DayPriceDefualt);
cmd.Parameters.Add(new SqlParameter("NightPriceDefualt", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.NightPriceDefualt);
cmd.Parameters.Add(new SqlParameter("UnitNameID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.UnitNameID);
cmd.Parameters.Add(new SqlParameter("RotinOrNot", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.RotinOrNot);
cmd.Parameters.Add(new SqlParameter("AgreeMentID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.AgreeMentID);
cmd.Parameters.Add(new SqlParameter("OnlyActive", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.OnlyActive);
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 Update(ClExplanSubject c)
{
SqlCommand cmd = new SqlCommand("PRC_ExplanSubject_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("ExplainSubjectID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.ExplainSubjectID);
cmd.Parameters.Add(new SqlParameter("SubjectID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.SubjectID);
cmd.Parameters.Add(new SqlParameter("ExplainName", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.ExplainName);
cmd.Parameters.Add(new SqlParameter("DayPriceDefualt", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.DayPriceDefualt);
cmd.Parameters.Add(new SqlParameter("NightPriceDefualt", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.NightPriceDefualt);
cmd.Parameters.Add(new SqlParameter("UnitNameID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.UnitNameID);
cmd.Parameters.Add(new SqlParameter("RotinOrNot", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.RotinOrNot);
cmd.Parameters.Add(new SqlParameter("ErthAzKol", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.ErthAzKol);
cmd.Parameters.Add(new SqlParameter("UseFromKol", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.UseFromKol);
cmd.Parameters.Add(new SqlParameter("Visible", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.Visible);
cmd.Parameters.Add(new SqlParameter("HavePlus", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.HavePlus);
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();
}
}
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);
}
