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, "خطا در ثبت عرصه از کل"); } } } }