protected void Button1_Click(object sender, EventArgs e)
{
GridViewRow grow;
int ii = 0;
for (int i = 0; i < Grid1.Rows.Count; i++)
{
grow = Grid1.Rows[i];
TextBox txtunitNumber = grow.FindControl("txtUniteNumber") as TextBox;
Label LblParkID = grow.FindControl("lblPakID") as Label;
Label LblAreaID = grow.FindControl("LblAreaID") as Label;
Label LblUseFromKol = grow.FindControl("LblUseFromKol") as Label;
SaveErth(Convert.ToInt32(LblParkID.Text), Convert.ToInt32(LblUseFromKol.Text == "" ? "0" : LblUseFromKol.Text));
}
ClArea cl = new ClArea();
cl.AgreementID = Convert.ToInt32(ddagree.SelectedValue);
cl.PeymanID = Convert.ToInt32(ddPeyman.SelectedValue);
int rrrttrt = AreaClass.SaveKhaki(cl);
if (rrrttrt == 0)
{
CSharp.Utility.ShowMsg(Page, CSharp.ProPertyData.MsgType.warning, "خطا در ثبت خاکی و غیر خاکی");
}
}
private DataSet CheckMabar(int parkid)
{//|| TXTExplanID.SelectedValue == "9181"
DataSet ds = new DataSet();
if (TXTExplanID.SelectedValue == "9185")
{
ClArea cl = new ClArea();
cl.ParkID = parkid;
cl.SubjectExplainID = 9185;
cl.AgreementID = Convert.ToInt32(ddagree.SelectedValue);
ds = AreaClass.GetListkhaki(cl);
return(ds);
}
else if (TXTExplanID.SelectedValue == "9181")
{
ClArea cl = new ClArea();
cl.ParkID = parkid;
cl.SubjectExplainID = 9181;
cl.AgreementID = Convert.ToInt32(ddagree.SelectedValue);
ds = AreaClass.GetListkhaki(cl);
return(ds);
}
else
{
return(ds);
}
}
private void CalKol()
{
if (DDSubjectExplainID.SelectedValue.ToString() != "-1")
{
return;
}
ClArea cl = new ClArea();
cl.SubjectID = Convert.ToInt32(ddSubject.SelectedValue);
cl.ParkID = Convert.ToInt32(DDParkID.SelectedValue);
DataSet ds = AreaClass.GetList(cl);
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
TXTUnitNumber.Text = dr["sumkol"].ToString();// +"00";
}
else
{
TXTUnitNumber.Text = "0";
}
ds.Dispose();
}
public void UpItem(object sender, EventArgs e)
{
String AreaID = ((HtmlAnchor)sender).HRef.ToString();
LblParamAreaID.Text = AreaID;
ClArea cl = new ClArea();
cl.AreaID = Convert.ToInt32(AreaID);
Data = cl;
LightBox.Value = "1";
}
protected void BtnInsert_Click(Object sender, System.EventArgs e)
{
ClArea cl = new ClArea();
cl = Data;
int t = 0;
if (DDSubjectExplainID.SelectedValue.ToString() == "-1")
{
t = AreaClass.insert(cl);
}
else
{
if (CSharp.PublicFunction.ModeInsert(LblParamAreaID.Text))
{
t = AreaClass.insert(cl);
}
else
{
t = AreaClass.Update(cl);
}
}
if (t == 0)
{
CSharp.Utility.ShowMsg(Page, CSharp.ProPertyData.MsgType.warning, "خطا در ثبت");
//LblMsg.ForeColor = System.Drawing.Color.Red;
//LblMsg.Text = "خطا در ثبت";
BindGrid();
}
else if (t == -1000)
{
CSharp.Utility.ShowMsg(Page, CSharp.ProPertyData.MsgType.warning, "متراژ وارده نباید از متراژ کل بیشتر شود");
}
else if (t == -2000)
{
CSharp.Utility.ShowMsg(Page, CSharp.ProPertyData.MsgType.warning, "ابتدا متراژ کل ها را باید وارد نمایید");
}
else if (t == -999)
{
CSharp.Utility.ShowMsg(Page, CSharp.ProPertyData.MsgType.warning, "برای این پارک در این شرح کار مقدار وارد شده است");
}
else
{
LblMsg.ForeColor = System.Drawing.Color.Green;
LblMsg.Text = "ثبت انجام شد.";
BindGrid();
}
LblParamAreaID.Text = "0";
//LightBox.Value = "0";
}
public void SaveAreaUseFromKol(int ParkD)
{
int retval = 0;
ClArea cl = new ClArea();
cl.ParkID = ParkD;
//cl.SubjectID = SubjectID;
//cl.SubjectExplainID = ExpanID;
//cl.AgreementID = AgreementID;
//cl.AreaID = AreaID;
//cl.UnitNumber = UnitNumber.ToString();
retval = AreaClass.Save2(cl);
}
public void SaveErth(int pid, int useFromKol)
{
ClArea cl = new ClArea();
cl.ParkID = pid;
cl.AgreementID = Convert.ToInt32(ddagree.SelectedValue);
cl.SubjectExplainID = Convert.ToInt32(TXTExplanID.SelectedValue);
int rrrttrt = AreaClass.SaveErth(cl);
if (rrrttrt == 0)
{
CSharp.Utility.ShowMsg(Page, CSharp.ProPertyData.MsgType.warning, "خطا در ثبت عرصه از کل");
}
BindGrid();
}
protected void BtnInsertAllPark_Click(object sender, EventArgs e)
{
ClArea cl = new ClArea();
cl = Data;
cl.SubjectID = Convert.ToInt32(ddSubject.SelectedValue);
int i = 0;
i = AreaClass.insertAllPark(cl);
if (i <= 0)
{
CSharp.Utility.ShowMsg(Page, CSharp.ProPertyData.MsgType.warning, "ابتدا همه پارکها راانتخاب نمایید");
}
else
{
BindGrid();
}
}
private int SaveArea(int ParkD, int SubjectID, int ExpanID, int AgreementID, int AreaID, string UnitNumber, TextBox t)
{
if (AreaID == null)
{
AreaID = 0;
}
if (UnitNumber == null)
{
UnitNumber = "";
}
if (UnitNumber != "")
{
int retval = 0;
ClArea cl = new ClArea();
cl.ParkID = ParkD;
cl.SubjectID = SubjectID;
cl.SubjectExplainID = ExpanID;
cl.AgreementID = AgreementID;
cl.AreaID = AreaID;
cl.UnitNumber = UnitNumber.ToString();
retval = AreaClass.Save(cl);
if (retval <= 0)
{
t.BackColor = System.Drawing.Color.Purple;
}
else
{
t.BackColor = System.Drawing.Color.LightGreen;
}
return(retval);
}
else
{
return(1);
}
}
//---------------------------------------------------------------------------------------------------------
public static DataSet GetListSubjectAgree(ClArea c)
{
SqlCommand cmd = new SqlCommand("PRC_SubjectAgree_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("AreaID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.AreaID);
cmd.Parameters.Add(new SqlParameter("ParkID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.ParkID);
cmd.Parameters.Add(new SqlParameter("SubjectExplainID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.SubjectExplainID);
cmd.Parameters.Add(new SqlParameter("UnitNumber", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.UnitNumber);
cmd.Parameters.Add(new SqlParameter("AgreementID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.AgreementID);
cmd.Parameters.Add(new SqlParameter("SubjectID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.SubjectID);
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 void BindGrid()
{
ClArea cl = new ClArea();
cl.AgreementID = Convert.ToInt32(AgreementID);
cl.SubjectID = Convert.ToInt32(ddSubject.SelectedValue);
cl.ParkID = Convert.ToInt32(DDParkID.SelectedValue.ToString());
DataSet ds = AreaClass.GetList(cl);
DataView dv = new DataView(ds.Tables[0]);
if (ViewState["AreaID "] == null)
{
ViewState["AreaID"] = "AreaID Desc";
}
dv.Sort = Securenamespace.SecureData.CheckSecurity(ViewState["AreaID"].ToString()).ToString();
GridView1.DataSource = dv;
GridView1.DataBind();
CalKol();
}
public static int Save(ClArea c)
{
SqlCommand cmd = new SqlCommand("PRC_Area_Save", 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("ParkID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.ParkID);
cmd.Parameters.Add(new SqlParameter("SubjectExplainID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.SubjectExplainID);
cmd.Parameters.Add(new SqlParameter("UnitNumber", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.UnitNumber);
cmd.Parameters.Add(new SqlParameter("AgreementID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.AgreementID);
cmd.Parameters.Add(new SqlParameter("SubjectID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.SubjectID);
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 void BindGridContetnt2()
{
int ParkID = 0;
ClArea cl = new ClArea();
cl.PeymanID = Convert.ToInt32(ddPeyman2.SelectedValue);
cl.AgreementID = Convert.ToInt32(ddPeyman.SelectedValue);
GridViewRow grow;
for (int i = 0; i < Grid1.Rows.Count; i++)
{
grow = Grid1.Rows[i];
ParkID = Convert.ToInt32(((grow.FindControl("lblPark") as Label).Text));
cl.ParkID = Convert.ToInt32(ParkID);
DataSet ds = AreaClass.GetList(cl);
Label txtChaman_Kol = grow.FindControl("txtChaman_Kol") as Label;
TextBox txtChamanAbDasti = grow.FindControl("txtChamanAbDasti") as TextBox;
TextBox txtChamanPSA = grow.FindControl("txtChamanPSA") as TextBox;
TextBox txtChamanPGP = grow.FindControl("txtChamanPGP") as TextBox;
Label txtParchinKol = grow.FindControl("LblParchin_Kol") as Label;
TextBox txtParchinAbChah = grow.FindControl("txtParchinAbChah") as TextBox;
TextBox txtParchinShilang = grow.FindControl("txtParchinShilang") as TextBox;
TextBox txtParchinFeshar = grow.FindControl("txtParchinFeshar") as TextBox;
Label txt_Poshesh_KOL = grow.FindControl("txt_Poshesh_KOL") as Label;
TextBox txtPoshesh_SHILANG = grow.FindControl("txtPoshesh_SHILANG") as TextBox;
TextBox txtPoshesh_Feshar = grow.FindControl("txtPoshesh_Feshar") as TextBox;
Label txt_Fasli_KOL = grow.FindControl("txt_Fasli_KOL") as Label;
TextBox txtFasli_SHILANG = grow.FindControl("txtFasli_SHILANG") as TextBox;
TextBox txtFasli_Feshar = grow.FindControl("txtFasli_Feshar") as TextBox;
Label txt_ROz_KOL = grow.FindControl("txt_ROz_KOL") as Label;
TextBox txtROz_SHILANG = grow.FindControl("txtROz_SHILANG") as TextBox;
TextBox txtROz_Feshar = grow.FindControl("txtROz_Feshar") as TextBox;
TextBox txtROz = grow.FindControl("txtROz") as TextBox;
TextBox txtROzDerakht = grow.FindControl("txtROzDerakht") as TextBox;
Label txt_drakht_KOL = grow.FindControl("txt_drakht_KOL") as Label;
TextBox txtdrakht_AbChah = grow.FindControl("txtdrakht_AbChah") as TextBox;
TextBox txtdrakht_Tashtak = grow.FindControl("txtdrakht_Tashtak") as TextBox;
TextBox txt_drakht_Shilang = grow.FindControl("txt_drakht_Shilang") as TextBox;
TextBox txtdrakht_Feshar = grow.FindControl("txtdrakht_Feshar") as TextBox;
TextBox txtdrakht_Tanker = grow.FindControl("txtdrakht_Tanker") as TextBox;
TextBox txtHashieKhiaban = grow.FindControl("txtHashieKhiaban") as TextBox;
for (int t = 0; t < ds.Tables[0].Rows.Count; t++)
{
////////چمن/متر مربع
if (ds.Tables[0].Rows[t]["ParkID"].ToString() == ParkID.ToString())
{
if (ds.Tables[0].Rows[t]["SubjectID"].ToString() == "15" && ds.Tables[0].Rows[t]["SubjectExplainID"].ToString() == "9017")
{
txtChamanAbDasti.Text = ds.Tables[0].Rows[t]["UnitNumber"].ToString();
}
if (ds.Tables[0].Rows[t]["SubjectID"].ToString() == "15" && ds.Tables[0].Rows[t]["SubjectExplainID"].ToString() == "9015")
{
txtChamanPSA.Text = ds.Tables[0].Rows[t]["UnitNumber"].ToString();
}
if (ds.Tables[0].Rows[t]["SubjectID"].ToString() == "15" && ds.Tables[0].Rows[t]["SubjectExplainID"].ToString() == "9019")
{
txtChamanPGP.Text = ds.Tables[0].Rows[t]["UnitNumber"].ToString();
}
txtChaman_Kol.Text = (
Convert.ToDecimal(txtChamanAbDasti.Text == "" ? "0" : txtChamanAbDasti.Text) +
Convert.ToDecimal(txtChamanPSA.Text == "" ? "0" : txtChamanPSA.Text) +
Convert.ToDecimal(txtChamanPGP.Text == "" ? "0" : txtChamanPGP.Text)).ToString();
//////////////////پرچینی /متر مربع
if (ds.Tables[0].Rows[t]["SubjectID"].ToString() == "2" && ds.Tables[0].Rows[t]["SubjectExplainID"].ToString() == "9041")
{
txtParchinAbChah.Text = ds.Tables[0].Rows[t]["UnitNumber"].ToString();
}
if (ds.Tables[0].Rows[t]["SubjectID"].ToString() == "2" && ds.Tables[0].Rows[t]["SubjectExplainID"].ToString() == "9043")
{
txtParchinShilang.Text = ds.Tables[0].Rows[t]["UnitNumber"].ToString();
}
if (ds.Tables[0].Rows[t]["SubjectID"].ToString() == "2" && ds.Tables[0].Rows[t]["SubjectExplainID"].ToString() == "9323")
{
txtParchinFeshar.Text = ds.Tables[0].Rows[t]["UnitNumber"].ToString();
}
txtParchinKol.Text = (
Convert.ToDecimal(txtParchinAbChah.Text == "" ? "0" : txtParchinAbChah.Text) +
Convert.ToDecimal(txtParchinShilang.Text == "" ? "0" : txtParchinShilang.Text) +
Convert.ToDecimal(txtParchinFeshar.Text == "" ? "0" : txtParchinFeshar.Text)
).ToString();
/////////پوششی/مترمربع
if (ds.Tables[0].Rows[t]["SubjectID"].ToString() == "10" && ds.Tables[0].Rows[t]["SubjectExplainID"].ToString() == "9061")
{
txtPoshesh_SHILANG.Text = ds.Tables[0].Rows[t]["UnitNumber"].ToString();
}
if (ds.Tables[0].Rows[t]["SubjectID"].ToString() == "10" && ds.Tables[0].Rows[t]["SubjectExplainID"].ToString() == "9013")
{
txtPoshesh_Feshar.Text = ds.Tables[0].Rows[t]["UnitNumber"].ToString();
}
txt_Poshesh_KOL.Text = (
Convert.ToDecimal(txtPoshesh_Feshar.Text == "" ? "0" : txtPoshesh_Feshar.Text)
+ Convert.ToDecimal(txtPoshesh_SHILANG.Text == "" ? "0" : txtPoshesh_SHILANG.Text)).ToString();
/////////گل فصلی / متر مربع
if (ds.Tables[0].Rows[t]["SubjectID"].ToString() == "12" && ds.Tables[0].Rows[t]["SubjectExplainID"].ToString() == "9077")
{
txtFasli_SHILANG.Text = ds.Tables[0].Rows[t]["UnitNumber"].ToString();
}
if (ds.Tables[0].Rows[t]["SubjectID"].ToString() == "12" && ds.Tables[0].Rows[t]["SubjectExplainID"].ToString() == "9073")
{
txtFasli_Feshar.Text = ds.Tables[0].Rows[t]["UnitNumber"].ToString();
}
txt_Fasli_KOL.Text = (
Convert.ToDecimal(txtFasli_SHILANG.Text == "" ? "0" : txtFasli_SHILANG.Text) +
Convert.ToDecimal(txtFasli_Feshar.Text == "" ? "0" : txtFasli_Feshar.Text)).ToString();
/////////رز و درختچه زینتی / متر مربع
if (ds.Tables[0].Rows[t]["SubjectID"].ToString() == "13" && ds.Tables[0].Rows[t]["SubjectExplainID"].ToString() == "9097")
{
txtROz_SHILANG.Text = ds.Tables[0].Rows[t]["UnitNumber"].ToString();
}
if (ds.Tables[0].Rows[t]["SubjectID"].ToString() == "13" && ds.Tables[0].Rows[t]["SubjectExplainID"].ToString() == "9095")
{
txtROz_Feshar.Text = ds.Tables[0].Rows[t]["UnitNumber"].ToString();
}
txt_ROz_KOL.Text = (
Convert.ToDecimal(txtROz_SHILANG.Text == "" ? "0" : txtROz_SHILANG.Text)
+ Convert.ToDecimal(txtROz_Feshar.Text == "" ? "0" : txtROz_Feshar.Text)).ToString();
if (ds.Tables[0].Rows[t]["SubjectID"].ToString() == "13" && ds.Tables[0].Rows[t]["SubjectExplainID"].ToString() == "9333")
{
txtROz.Text = ds.Tables[0].Rows[t]["UnitNumber"].ToString();
}
if (ds.Tables[0].Rows[t]["SubjectID"].ToString() == "13" && ds.Tables[0].Rows[t]["SubjectExplainID"].ToString() == "9334")
{
txtROzDerakht.Text = ds.Tables[0].Rows[t]["UnitNumber"].ToString();
}
/////////درخت معابر و جنگلی داخل محدوده / متر مربع
if (ds.Tables[0].Rows[t]["SubjectID"].ToString() == "14" && ds.Tables[0].Rows[t]["SubjectExplainID"].ToString() == "9114")
{
txtdrakht_AbChah.Text = ds.Tables[0].Rows[t]["UnitNumber"].ToString();
}
if (ds.Tables[0].Rows[t]["SubjectID"].ToString() == "14" && ds.Tables[0].Rows[t]["SubjectExplainID"].ToString() == "9118")
{
txtdrakht_Tashtak.Text = ds.Tables[0].Rows[t]["UnitNumber"].ToString();
}
if (ds.Tables[0].Rows[t]["SubjectID"].ToString() == "14" && ds.Tables[0].Rows[t]["SubjectExplainID"].ToString() == "9120")
{
txt_drakht_Shilang.Text = ds.Tables[0].Rows[t]["UnitNumber"].ToString();
}
if (ds.Tables[0].Rows[t]["SubjectID"].ToString() == "14" && ds.Tables[0].Rows[t]["SubjectExplainID"].ToString() == "9116")
{
txtdrakht_Feshar.Text = ds.Tables[0].Rows[t]["UnitNumber"].ToString();
}
if (ds.Tables[0].Rows[t]["SubjectID"].ToString() == "14" && ds.Tables[0].Rows[t]["SubjectExplainID"].ToString() == "9122")
{
txtdrakht_Tanker.Text = ds.Tables[0].Rows[t]["UnitNumber"].ToString();
}
if (ds.Tables[0].Rows[t]["SubjectID"].ToString() == "14" && ds.Tables[0].Rows[t]["SubjectExplainID"].ToString() == "9335")
{
txtHashieKhiaban.Text = ds.Tables[0].Rows[t]["UnitNumber"].ToString();
}
txt_drakht_KOL.Text = (
Convert.ToDecimal(txtdrakht_AbChah.Text == "" ? "0" : txtdrakht_AbChah.Text)
+ Convert.ToDecimal(txtdrakht_Tashtak.Text == "" ? "0" : txtdrakht_Tashtak.Text)
+ Convert.ToDecimal(txtdrakht_Feshar.Text == "" ? "0" : txtdrakht_Feshar.Text)
+ Convert.ToDecimal(txt_drakht_Shilang.Text == "" ? "0" : txt_drakht_Shilang.Text)
+ Convert.ToDecimal(txtdrakht_Tanker.Text == "" ? "0" : txtdrakht_Tanker.Text).ToString()
+ Convert.ToDecimal(txtHashieKhiaban.Text == "" ? "0" : txtHashieKhiaban.Text)).ToString();
/////////////////////////////////////////////////////////
}
}
calallcolumn((TextBox)Grid1.HeaderRow.FindControl("txtHashieKhiabanSum"), txtHashieKhiaban);
calallcolumn((TextBox)Grid1.HeaderRow.FindControl("txtchamanDastiSum"), txtChamanAbDasti);
calallcolumn((TextBox)Grid1.HeaderRow.FindControl("txtchamanPSASum"), txtChamanPSA);
calallcolumn((TextBox)Grid1.HeaderRow.FindControl("txtchamanPGPSum"), txtChamanPGP);
calallcolumn((TextBox)Grid1.HeaderRow.FindControl("txtparchinAbChahSum"), txtParchinAbChah);
calallcolumn((TextBox)Grid1.HeaderRow.FindControl("txtParchinShilangSum"), txtParchinShilang);
calallcolumn((TextBox)Grid1.HeaderRow.FindControl("txtParchinFesharSum"), txtParchinFeshar);
calallcolumn((TextBox)Grid1.HeaderRow.FindControl("txtPosheshiShilangSum"), txtPoshesh_SHILANG);
calallcolumn((TextBox)Grid1.HeaderRow.FindControl("txtPosheshiFesharSum"), txtPoshesh_Feshar);
calallcolumn((TextBox)Grid1.HeaderRow.FindControl("txtGolfasliFesharSum"), txtFasli_Feshar);
calallcolumn((TextBox)Grid1.HeaderRow.FindControl("txtRozShilangSum"), txtROz_SHILANG);
calallcolumn((TextBox)Grid1.HeaderRow.FindControl("txtRozfesharSum"), txtROz_Feshar);
calallcolumn((TextBox)Grid1.HeaderRow.FindControl("txtderakhtchahSum"), txtdrakht_AbChah);
calallcolumn((TextBox)Grid1.HeaderRow.FindControl("txtderakhttashtakSum"), txtdrakht_Tashtak);
calallcolumn((TextBox)Grid1.HeaderRow.FindControl("txtderakhtshilangsum"), txt_drakht_Shilang);
calallcolumn((TextBox)Grid1.HeaderRow.FindControl("txtderakhtfesharSum"), txtdrakht_Feshar);
calallcolumn((TextBox)Grid1.HeaderRow.FindControl("txtderakhttankerSum"), txtdrakht_Tanker);
calallcolumn((TextBox)Grid1.HeaderRow.FindControl("txtGolfasliShilangSum"), txtFasli_SHILANG);
calallcolumn((TextBox)Grid1.HeaderRow.FindControl("txtRozSum"), txtROz);
calallcolumn((TextBox)Grid1.HeaderRow.FindControl("txtRozderakhtSum"), txtROzDerakht);
ds.Dispose();
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
GridViewRow grow;
for (int i = 0; i < Grid1.Rows.Count; i++)
{
grow = Grid1.Rows[i];
Label txtChaman_Kol = grow.FindControl("txtChaman_Kol") as Label;
TextBox txtChamanAbDasti = grow.FindControl("txtChamanAbDasti") as TextBox;
TextBox txtChamanPSA = grow.FindControl("txtChamanPSA") as TextBox;
TextBox txtChamanPGP = grow.FindControl("txtChamanPGP") as TextBox;
Label txtParchinKol = grow.FindControl("LblParchin_Kol") as Label;
TextBox txtParchinAbChah = grow.FindControl("txtParchinAbChah") as TextBox;
TextBox txtParchinShilang = grow.FindControl("txtParchinShilang") as TextBox;
TextBox txtParchinFeshar = grow.FindControl("txtParchinFeshar") as TextBox;
Label txt_Poshesh_KOL = grow.FindControl("txt_Poshesh_KOL") as Label;
TextBox txtPoshesh_SHILANG = grow.FindControl("txtPoshesh_SHILANG") as TextBox;
TextBox txtPoshesh_Feshar = grow.FindControl("txtPoshesh_Feshar") as TextBox;
Label txt_Fasli_KOL = grow.FindControl("txt_Fasli_KOL") as Label;
TextBox txtFasli_SHILANG = grow.FindControl("txtFasli_SHILANG") as TextBox;
TextBox txtFasli_Feshar = grow.FindControl("txtFasli_Feshar") as TextBox;
Label txt_ROz_KOL = grow.FindControl("txt_ROz_KOL") as Label;
TextBox txtROz_SHILANG = grow.FindControl("txtROz_SHILANG") as TextBox;
TextBox txtROz_Feshar = grow.FindControl("txtROz_Feshar") as TextBox;
TextBox txtROz = grow.FindControl("txtROz") as TextBox;
TextBox txtROzderakht = grow.FindControl("txtROzDerakht") as TextBox;
Label txt_drakht_KOL = grow.FindControl("txt_drakht_KOL") as Label;
TextBox txtdrakht_AbChah = grow.FindControl("txtdrakht_AbChah") as TextBox;
TextBox txtdrakht_Tashtak = grow.FindControl("txtdrakht_Tashtak") as TextBox;
TextBox txt_drakht_Shilang = grow.FindControl("txt_drakht_Shilang") as TextBox;
TextBox txtdrakht_Feshar = grow.FindControl("txtdrakht_Feshar") as TextBox;
TextBox txtdrakht_Tanker = grow.FindControl("txtdrakht_Tanker") as TextBox;
TextBox txtHashieKhiaban = grow.FindControl("txtHashieKhiaban") as TextBox;
int ParkID = Convert.ToInt32(((grow.FindControl("lblPark") as Label).Text));
/////چمن/متر مربع 15
//////////////////////////////////////////////////////////////////////////////////////////
SaveArea(ParkID, 15, 9017, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtChamanAbDasti.Text, txtChamanAbDasti);
SaveArea(ParkID, 15, 9018, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtChamanAbDasti.Text, txtChamanAbDasti);
SaveArea(ParkID, 15, 9015, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtChamanPSA.Text, txtChamanPSA);
SaveArea(ParkID, 15, 9016, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtChamanPSA.Text, txtChamanPSA);
SaveArea(ParkID, 15, 9019, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtChamanPGP.Text, txtChamanPGP);
SaveArea(ParkID, 15, 9020, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtChamanPGP.Text, txtChamanPGP);
//////////////////////////////////////////////////////////////////////////////////////////
/////پرچینی /متر مربع 2
SaveArea(ParkID, 2, 9041, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtParchinAbChah.Text, txtParchinAbChah);
SaveArea(ParkID, 2, 9042, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtParchinAbChah.Text, txtParchinAbChah);
SaveArea(ParkID, 2, 9043, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtParchinShilang.Text, txtParchinShilang);
SaveArea(ParkID, 2, 9044, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtParchinShilang.Text, txtParchinShilang);
SaveArea(ParkID, 2, 9040, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtParchinFeshar.Text, txtParchinFeshar);
SaveArea(ParkID, 2, 9323, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtParchinFeshar.Text, txtParchinFeshar);
//////////////////////////////////////////////////////////////////////////////////////////
/////پوششی/مترمربع 2
SaveArea(ParkID, 10, 9061, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtPoshesh_SHILANG.Text, txtPoshesh_SHILANG);
SaveArea(ParkID, 10, 9062, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtPoshesh_SHILANG.Text, txtPoshesh_SHILANG);
SaveArea(ParkID, 10, 9013, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtPoshesh_Feshar.Text, txtPoshesh_Feshar);
SaveArea(ParkID, 10, 9014, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtPoshesh_Feshar.Text, txtPoshesh_Feshar);
//////////////////////////////////////////////////////////////////////////////////////////
/////گل فصلی / متر مربع 12
SaveArea(ParkID, 12, 9077, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtFasli_SHILANG.Text, txtFasli_SHILANG);
SaveArea(ParkID, 12, 9078, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtFasli_SHILANG.Text, txtFasli_SHILANG);
SaveArea(ParkID, 12, 9073, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtFasli_Feshar.Text, txtFasli_Feshar);
SaveArea(ParkID, 12, 9074, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtFasli_Feshar.Text, txtFasli_Feshar);
//////////////////////////////////////////////////////////////////////////////////////////
/////رز و درختچه زینتی / متر مربع 13
SaveArea(ParkID, 13, 9097, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtROz_SHILANG.Text, txtROz_SHILANG);
SaveArea(ParkID, 13, 9098, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtROz_SHILANG.Text, txtROz_SHILANG);
SaveArea(ParkID, 13, 9095, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtROz_Feshar.Text, txtROz_Feshar);
SaveArea(ParkID, 13, 9096, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtROz_Feshar.Text, txtROz_Feshar);
SaveArea(ParkID, 13, 9333, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtROz.Text, txtROz);
SaveArea(ParkID, 13, 9334, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtROzderakht.Text, txtROzderakht);
//////////////////////////////////////////////////////////////////////////////////////////
/////14درخت معابر و جنگلی داخل محدوده / متر مربع
SaveArea(ParkID, 14, 9114, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtdrakht_AbChah.Text, txtdrakht_AbChah);
SaveArea(ParkID, 14, 9115, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtdrakht_AbChah.Text, txtdrakht_AbChah);
SaveArea(ParkID, 14, 9118, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtdrakht_Tashtak.Text, txtdrakht_Tashtak);
SaveArea(ParkID, 14, 9119, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtdrakht_Tashtak.Text, txtdrakht_Tashtak);
SaveArea(ParkID, 14, 9120, Convert.ToInt32(ddPeyman.SelectedValue), 0, txt_drakht_Shilang.Text, txt_drakht_Shilang);
SaveArea(ParkID, 14, 9121, Convert.ToInt32(ddPeyman.SelectedValue), 0, txt_drakht_Shilang.Text, txt_drakht_Shilang);
SaveArea(ParkID, 14, 9116, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtdrakht_Feshar.Text, txtdrakht_Feshar);
SaveArea(ParkID, 14, 9117, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtdrakht_Feshar.Text, txtdrakht_Feshar);
SaveArea(ParkID, 14, 9122, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtdrakht_Tanker.Text, txtdrakht_Tanker);
SaveArea(ParkID, 14, 9335, Convert.ToInt32(ddPeyman.SelectedValue), 0, txtHashieKhiaban.Text, txtHashieKhiaban);
//////////////////////////////////////////////////////////////////////////////////////////
//if(ddPeyman.SelectedValue=="0")
// SaveAreaUseFromKol(ParkID);
if (Convert.ToInt32(ddPeyman.SelectedValue) == 0)
{
ClArea cl = new ClArea();
cl.ParkID = ParkID;
cl.AgreementID = 0;
int rrrttrt = AreaClass.SaveErth(cl);
if (rrrttrt == 0)
{
CSharp.Utility.ShowMsg(Page, CSharp.ProPertyData.MsgType.warning, "خطا در ثبت عرصه از کل");
}
}
}
}
