protected void btnInsert_Click(object sender, EventArgs e) { ClCuttingTree cl = new ClCuttingTree(); cl.Address = txtAddress.Text; cl.Bon = Convert.ToInt32(txtBon.Text); cl.Count = Convert.ToInt32(txtCount.Text); cl.date = CtlDatePick.Text; cl.dddeeesssccc = txtcomment.Text; cl.Desc = txtcomment.Text; cl.GeoTree = latlong.Value; cl.HaghighiId = Convert.ToInt32(txtHaghighiId.Value); cl.id = Convert.ToInt32(txtid.Value); cl.LicesnceTypeid = 0; cl.MantagheId = Convert.ToInt32(ddRegion.SelectedValue); cl.StreetTypeid = Convert.ToInt32(ddlStreetType.SelectedValue); cl.TreeTypeId = Convert.ToInt32(ddlTreeType.SelectedValue); int i = 0; if (cl.id == 0) { i = CuttingTreeSpace.CuttingTreeClass2.insert(cl); } else { i = CuttingTreeSpace.CuttingTreeClass2.Update(cl); } if (i == 0) { CSharp.Utility.ShowMsg(Page, CSharp.ProPertyData.MsgType.warning, "خطا در ثبت"); } }
//--------------------------------------------------------------------------------------------------------- public static DataSet GetList(ClCuttingTree c) { SqlCommand cmd = new SqlCommand("PRC_CuttingTree_GetListMap", cnn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("UserIDLog", SqlDbType.NVarChar)).Value = 1;// 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("id", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.id); cmd.Parameters.Add(new SqlParameter("TreeTypeId", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.TreeTypeId); cmd.Parameters.Add(new SqlParameter("Count", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.Count); cmd.Parameters.Add(new SqlParameter("Bon", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.Bon); cmd.Parameters.Add(new SqlParameter("date", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.date); cmd.Parameters.Add(new SqlParameter("Address", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.Address); cmd.Parameters.Add(new SqlParameter("x", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.x); cmd.Parameters.Add(new SqlParameter("y", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.y); cmd.Parameters.Add(new SqlParameter("image", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.image); cmd.Parameters.Add(new SqlParameter("StreetTypeid", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.StreetTypeid); cmd.Parameters.Add(new SqlParameter("PersonalId", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.PersonalId); cmd.Parameters.Add(new SqlParameter("Peyman", SqlDbType.Bit)).Value = Securenamespace.SecureData.CheckSecurity(c.Peyman); cmd.Parameters.Add(new SqlParameter("Peymanid", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.Peymanid); cmd.Parameters.Add(new SqlParameter("MantagheId", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.MantagheId); cmd.Parameters.Add(new SqlParameter("Mojavez", SqlDbType.Bit)).Value = Securenamespace.SecureData.CheckSecurity(c.Mojavez); cmd.Parameters.Add(new SqlParameter("HaghighiId", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.HaghighiId); cmd.Parameters.Add(new SqlParameter("LicesnceTypeid", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.LicesnceTypeid); cmd.Parameters.Add(new SqlParameter("Title", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.Title); cmd.Parameters.Add(new SqlParameter("dddeeesssccc", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.dddeeesssccc); cmd.Parameters.Add(new SqlParameter("recRoleID", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.recRoleID); cmd.Parameters.Add(new SqlParameter("status", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.status); cmd.Parameters.Add(new SqlParameter("GeoTree", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.GeoTree); cmd.Parameters.Add(new SqlParameter("Desc", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.Desc); cmd.Parameters.Add(new SqlParameter("PointGeo", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.PointGeo); 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 string GetMapReport(ClCuttingTree oobbjj) { //string text = File.ReadAllText(@"D:\B\file.txt", Encoding.UTF8); //return text; ClCuttingTree cl2 = new ClCuttingTree(); if (oobbjj.PersonalId != 0) { cl2.PersonalId = oobbjj.PersonalId; // Convert.ToInt32(Session["PersonalID"].ToString()==null ? "1":"0"); } if (oobbjj.id != 0) { cl2.id = oobbjj.id; } // cl2.PersonalId = 1;// Convert.ToInt32(objj.PersonalId); DataSet ds = CuttingTreeSpace.CuttingTreeClass2.GetList(cl2); List <ClCuttingTree> messages = new List <GreenSpaceCL.ClCuttingTree>(); DataRow dr; if (ds == null) { return(""); } if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { ClCuttingTree cl = new ClCuttingTree(); cl.PersonalId = 1; dr = ds.Tables[0].Rows[i]; cl.Bon = Convert.ToInt32(dr["Bon"].ToString() == "" ?"0":dr["Bon"].ToString()); cl.Address = dr["Address"].ToString(); cl.Count = Convert.ToInt32(dr["Count"].ToString() == "" ? "0" : dr["Count"].ToString()); cl.dddeeesssccc = dr["Desc"].ToString(); cl.Desc = dr["Desc"].ToString(); cl.GeoTree = dr["GeoTree"].ToString(); cl.LicesnceTypeid = Convert.ToInt32(dr["LicesnceTypeid"].ToString() == "" ? "0" : dr["LicesnceTypeid"].ToString()); cl.MantagheId = Convert.ToInt32(dr["MantagheId"].ToString() == "" ? "0" : dr["MantagheId"].ToString()); cl.Mojavez = Convert.ToInt32(dr["Mojavez"].ToString() == "True" ? "1" :"0"); cl.StreetTypeid = Convert.ToInt32(dr["StreetTypeid"].ToString() == "" ? "0" : dr["StreetTypeid"].ToString()); cl.Title = dr["Title"].ToString(); cl.TreeTypeId = Convert.ToInt32(dr["TreeTypeId"].ToString() == "" ? "0" : dr["TreeTypeId"].ToString()); cl.PointGeo = dr["PointGeo"].ToString(); cl.P = dr["P"].ToString(); cl.lat = dr["lat"].ToString(); cl.longg = dr["Long"].ToString(); cl.id = Convert.ToInt32(dr["id"].ToString()); messages.Add(cl); } } string ff = GetPointGeoJasonBySubGroupColor(messages); return(ff); }
public string savepoint(ClCuttingTree objectt) { ClCuttingTree cl = new ClCuttingTree(); cl = objectt; int i = 0; ///cl.PersonalId = 1; if (objectt.id == 0 || objectt.id == null) { i = CuttingTreeSpace.CuttingTreeClass2.insert(cl); } else { i = CuttingTreeSpace.CuttingTreeClass2.Update(cl); } return(i.ToString()); //objectt.Bon = 0; //objectt.Count = 1; //string constr = ConfigurationManager.ConnectionStrings["GreenCnn"].ConnectionString; //using (SqlConnection con = new SqlConnection(constr)) //{ // //using (SqlCommand cmd = new SqlCommand("INSERT INTO Tbl_CuttingTree(bon,Count,PointGeo) VALUES(@Bon, @Count,@PointGeo)")) // using (SqlCommand cmd = new SqlCommand("PRC_CuttingTree_Insert")) // { // cmd.CommandType = CommandType.StoredProcedure; // cmd.Parameters.AddWithValue("@Bon", objectt.Bon); // cmd.Parameters.AddWithValue("@Count", objectt.Count); // cmd.Parameters.AddWithValue("@PointGeo", objectt.PointGeo); // cmd.Connection = con; // con.Open(); // cmd.ExecuteNonQuery(); // con.Close(); // } //} }
public string GetPointGeoJasonBySubGroupColor(List <ClCuttingTree> messages) { ClCuttingTree msg = new ClCuttingTree(); //List<ClTreeBonCuttingDB> groups = msg.PersonalID; string jason = "{" + "\"type\": \"FeatureCollection\"," + "\"crs\": { \"type\": \"name\", \"properties\": { \"name\": \"urn:ogc:def:crs:EPSG::32639\" } }," + "\"features\": ["; string p = ""; foreach (ClCuttingTree db in messages) { if (!string.IsNullOrEmpty(db.PointGeo)) { p = "[" + db.lat + "," + db.longg + "]"; // p = db.SHAPE.ToString().Remove(0, 6).Replace('(', '[').Replace(' ', ',').Replace(')', ']'); // messages cc = messages.Find(t => t.SubgroupId == db.SubGroupId); string color = "#000000"; //if (db != null) // color = db.Icon; jason += "{ \"type\": \"Feature\", \"properties\": { \"id\": \" " + db.id + "\" ," + "\"comment\": \" " + db.Desc + "\" ," + "\"Address\": \" " + db.Address + "\" ," + "\"DatePick\": \" " + db.date + "\" ," + "\"Bon\": \" " + db.Bon + "\" ," + "\"Count\": \" " + db.Count + "\" ," + "\"Region\": \" " + db.MantagheId + "\" ," + "\"LicesnceType\": \" " + db.LicesnceTypeid + "\" ," + "\"StreetType\": \" " + db.StreetTypeid + "\" ," + " \"Color\":\"" + color + "\" }, \"geometry\": { \"type\": \"Point\", \"coordinates\": " + p + " } },"; } } jason = jason.Remove(jason.Length - 1, 1); jason += "]}"; return(jason); }
public string deleteTree(ClCuttingTree oobbjj) { string ff = CuttingTreeClass.Delete(Convert.ToInt32(oobbjj.PersonalId)).ToString(); return(ff); }