public static Model.ControlPoint GetModel(int ID) { string strSql = "select * from ControlPoint where ID = '" + ID + "'"; Model.ControlPoint model = new Model.ControlPoint(); DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString); model.ID = ID; if (ds.Tables[0].Rows.Count > 0) { model.MarkName = Convert.ToString(ds.Tables[0].Rows[0]["MarkName"]); model.MarkID = Convert.ToString(ds.Tables[0].Rows[0]["MarkID"]); model.AccuracyClass = Convert.ToString(ds.Tables[0].Rows[0]["AccuracyClass"]); model.B = Convert.ToDouble(ds.Tables[0].Rows[0]["B"]); model.L = Convert.ToDouble(ds.Tables[0].Rows[0]["L"]); try { model.H = Convert.ToDouble(ds.Tables[0].Rows[0]["H"]); } catch (Exception) { //model.H = 0; } model.GCgrade = Convert.ToString(ds.Tables[0].Rows[0]["GCgrade"]); model.BZ = Convert.ToString(ds.Tables[0].Rows[0]["BZ"]); model.PointRemark = Convert.ToString(ds.Tables[0].Rows[0]["PointRemark"]); return(model); } else { return(null); } }
/// <summary> /// 更新一条数据,根据ID /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool Update(Model.ControlPoint model) { string strSql = "update ControlPoint set MarkName=@MarkName,MarkID=@MarkID,AccuracyClass=@AccuracyClass,B=@B,L=@L,H=@H,GCgrade=@GCgrade,BZ=@BZ,PointRemark=@PointRemark where ID = " + model.ID.ToString(); SqlParameter MarkName = new SqlParameter("MarkName", SqlDbType.NVarChar); MarkName.Value = model.MarkName; SqlParameter MarkID = new SqlParameter("MarkID", SqlDbType.NVarChar); MarkID.Value = model.MarkID; SqlParameter AccuracyClass = new SqlParameter("AccuracyClass", SqlDbType.NVarChar); AccuracyClass.Value = model.AccuracyClass; SqlParameter B = new SqlParameter("B", SqlDbType.Float); B.Value = model.B; SqlParameter L = new SqlParameter("L", SqlDbType.Float); L.Value = model.L; SqlParameter H = new SqlParameter("H", SqlDbType.Float); H.Value = model.H; SqlParameter GCgrade = new SqlParameter("GCgrade", SqlDbType.NVarChar); GCgrade.Value = model.GCgrade; SqlParameter BZ = new SqlParameter("BZ", SqlDbType.NVarChar); BZ.Value = model.BZ; SqlParameter PointRemark = new SqlParameter("PointRemark", SqlDbType.NVarChar); PointRemark.Value = model.PointRemark; return(DBHelperSQL.GetNums(strSql, new SqlParameter[] { MarkName, MarkID, AccuracyClass, B, L, H, GCgrade, BZ, PointRemark }, connectionString) == 1 ? true : false); }
/// <summary> /// 增加一个控制点信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool Add(Model.ControlPoint model) { string strSql = "insert into ControlPoint(MarkName,MarkID,AccuracyClass,B,L,H,GCgrade,BZ,PointRemark) values(@MarkName,@MarkID,@AccuracyClass,@B,@L,@H,@GCgrade,@BZ,@PointRemark)"; SqlParameter MarkName = new SqlParameter("MarkName", SqlDbType.NVarChar); MarkName.Value = model.MarkName; SqlParameter MarkID = new SqlParameter("MarkID", SqlDbType.NVarChar); MarkID.Value = model.MarkID; SqlParameter AccuracyClass = new SqlParameter("AccuracyClass", SqlDbType.NVarChar); AccuracyClass.Value = model.AccuracyClass; SqlParameter B = new SqlParameter("B", SqlDbType.Float); B.Value = model.B; SqlParameter L = new SqlParameter("L", SqlDbType.Float); L.Value = model.L; SqlParameter H = new SqlParameter("H", SqlDbType.Float); H.Value = model.H; SqlParameter GCgrade = new SqlParameter("GCgrade", SqlDbType.NVarChar); GCgrade.Value = model.GCgrade; SqlParameter BZ = new SqlParameter("BZ", SqlDbType.NVarChar); BZ.Value = model.BZ; SqlParameter PointRemark = new SqlParameter("PointRemark", SqlDbType.NVarChar); PointRemark.Value = model.PointRemark; return(DBHelperSQL.GetNums(strSql, new SqlParameter[] { MarkName, MarkID, AccuracyClass, B, L, H, GCgrade, BZ, PointRemark }, connectionString) == 1 ? true : false); }
protected void Page_Load(object sender, EventArgs e) { if (Request["action"] == "save") { Model.ControlPoint mcp = new Model.ControlPoint(); mcp.MarkID = Request.Form["MarkID"].ToString().Trim(); mcp.MarkName = Request.Form["MarkName"].ToString().Trim(); mcp.AccuracyClass = Request.Form["AccuracyClass"].ToString().Trim(); mcp.BZ = Request.Form["BZ"].ToString().Trim(); mcp.GCgrade = Request.Form["GCgrade"].ToString().Trim(); mcp.B = double.Parse(Request.Form["B"].ToString().Trim()); mcp.L = double.Parse(Request.Form["L"].ToString().Trim()); mcp.H = double.Parse(Request.Form["H"].ToString().Trim()); if (DAL.ControlPoint.Exists(mcp.MarkName)) { Response.Clear(); Response.Write("2"); Response.End(); return; } else { bool result = DAL.ControlPoint.Add(mcp); if (result) { Response.Clear(); Response.Write("1"); Response.End(); return; } else { Response.Clear(); Response.Write("0"); Response.End(); } } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["UserName"] == null) { Response.Write("<script>alert(\"请登录\");location.href = location.origin+\"/forms/Index.aspx\";</script>"); Response.End(); } if (!IsPostBack) { string id = null; id = Request["id"]; pointid.Value = id.ToString(); Model.ControlPoint mcp = DAL.ControlPoint.GetModel(int.Parse(id.ToString())); MarkName.Value = mcp.MarkName; MarkID.Value = mcp.MarkID; BZ.Value = mcp.BZ; AccuracyClass.Value = mcp.AccuracyClass; GCgrade.Value = mcp.GCgrade; if (mcp.PointRemark == "" || mcp.PointRemark == null) { viewPointRemark.Disabled = true; } B.Value = mcp.B.ToString(); L.Value = mcp.L.ToString(); try { H.Value = mcp.H.ToString(); } catch (Exception) { } PointRemark.Value = mcp.PointRemark; } else { if (Request["upload"] == "PointRemark") { string filename = Request.Files["FilePointRemark"].FileName; string MarkName = Request.Form["MarkName"].ToString().Trim(); int ids = int.Parse(Request.Form["pointid"].ToString()); string[] filenames = filename.Split('.'); Request.Files["FilePointRemark"].SaveAs(Server.MapPath("~/upload/PointRemark/") + MarkName + "." + filenames[filenames.Length - 1]); Model.ControlPoint mcp = DAL.ControlPoint.GetModel(ids); mcp.PointRemark = "/upload/PointRemark/" + MarkName + "." + filenames[filenames.Length - 1]; DAL.ControlPoint.Update(mcp); Response.Clear(); Response.Write("1"); Response.End(); } if (Request["action"] == "save") { int ids = int.Parse(Request.Form["pointid"].ToString()); Model.ControlPoint mcp = DAL.ControlPoint.GetModel(ids); mcp.MarkID = Request.Form["MarkID"].ToString().Trim(); mcp.MarkName = Request.Form["MarkName"].ToString().Trim(); mcp.AccuracyClass = Request.Form["AccuracyClass"].ToString().Trim(); mcp.BZ = Request.Form["BZ"].ToString().Trim(); mcp.GCgrade = Request.Form["GCgrade"].ToString().Trim(); mcp.B = double.Parse(Request.Form["B"].ToString().Trim()); mcp.L = double.Parse(Request.Form["L"].ToString().Trim()); mcp.H = double.Parse(Request.Form["H"].ToString().Trim()); DAL.ControlPoint.Update(mcp); Response.Clear(); Response.Write("1"); Response.End(); } } }