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();
}
}
}
