/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.cjplpback GetModel(string Exp_NoOri) { StringBuilder strSql = new StringBuilder(); strSql.Append("select MapCode,StormSystem_ID,Exp_NoOri,Type,X,Y,High,WellDeep,Offset,Feature,Subsid,Model,WellPipes,WellShape,WellSize,WellMaterial,WaterDeep,MudDeep,Inlet_Type,OutfallType,ReceiveWater,Flap,Flap_Diameter,Flap_TopEle,Flap_BotEle,Flap_Material,Address,PointPosition,DataSource,Visibility,Sdate,Mdate,Manhole_Type,status,Note,FileName,Uploadtime,Exp_No,ExpNoTime from cjplpback "); strSql.Append(" where Exp_NoOri=@Exp_NoOri "); MySqlParameter[] parameters = { new MySqlParameter("@Exp_NoOri", MySqlDbType.VarChar, 255) }; parameters[0].Value = Exp_NoOri; Maticsoft.Model.cjplpback model = new Maticsoft.Model.cjplpback(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Maticsoft.Model.cjplpback model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into cjplpback("); strSql.Append("MapCode,StormSystem_ID,Exp_NoOri,Type,X,Y,High,WellDeep,Offset,Feature,Subsid,Model,WellPipes,WellShape,WellSize,WellMaterial,WaterDeep,MudDeep,Inlet_Type,OutfallType,ReceiveWater,Flap,Flap_Diameter,Flap_TopEle,Flap_BotEle,Flap_Material,Address,PointPosition,DataSource,Visibility,Sdate,Mdate,Manhole_Type,status,Note,FileName,Uploadtime,Exp_No,ExpNoTime)"); strSql.Append(" values ("); strSql.Append("@MapCode,@StormSystem_ID,@Exp_NoOri,@Type,@X,@Y,@High,@WellDeep,@Offset,@Feature,@Subsid,@Model,@WellPipes,@WellShape,@WellSize,@WellMaterial,@WaterDeep,@MudDeep,@Inlet_Type,@OutfallType,@ReceiveWater,@Flap,@Flap_Diameter,@Flap_TopEle,@Flap_BotEle,@Flap_Material,@Address,@PointPosition,@DataSource,@Visibility,@Sdate,@Mdate,@Manhole_Type,@status,@Note,@FileName,@Uploadtime,@Exp_No,@ExpNoTime)"); MySqlParameter[] parameters = { new MySqlParameter("@MapCode", MySqlDbType.VarChar, 50), new MySqlParameter("@StormSystem_ID", MySqlDbType.VarChar, 100), new MySqlParameter("@Exp_NoOri", MySqlDbType.VarChar, 255), new MySqlParameter("@Type", MySqlDbType.VarChar, 10), new MySqlParameter("@X", MySqlDbType.Decimal, 10), new MySqlParameter("@Y", MySqlDbType.Decimal, 10), new MySqlParameter("@High", MySqlDbType.Decimal, 10), new MySqlParameter("@WellDeep", MySqlDbType.Decimal, 7), new MySqlParameter("@Offset", MySqlDbType.VarChar, 255), new MySqlParameter("@Feature", MySqlDbType.VarChar, 255), new MySqlParameter("@Subsid", MySqlDbType.VarChar, 255), new MySqlParameter("@Model", MySqlDbType.VarChar, 255), new MySqlParameter("@WellPipes", MySqlDbType.Int32, 10), new MySqlParameter("@WellShape", MySqlDbType.VarChar, 50), new MySqlParameter("@WellSize", MySqlDbType.VarChar, 150), new MySqlParameter("@WellMaterial", MySqlDbType.VarChar, 255), new MySqlParameter("@WaterDeep", MySqlDbType.Decimal, 10), new MySqlParameter("@MudDeep", MySqlDbType.Decimal, 10), new MySqlParameter("@Inlet_Type", MySqlDbType.VarChar, 10), new MySqlParameter("@OutfallType", MySqlDbType.VarChar, 10), new MySqlParameter("@ReceiveWater", MySqlDbType.VarChar, 255), new MySqlParameter("@Flap", MySqlDbType.VarChar, 10), new MySqlParameter("@Flap_Diameter", MySqlDbType.Decimal, 10), new MySqlParameter("@Flap_TopEle", MySqlDbType.Decimal, 10), new MySqlParameter("@Flap_BotEle", MySqlDbType.Decimal, 10), new MySqlParameter("@Flap_Material", MySqlDbType.VarChar, 255), new MySqlParameter("@Address", MySqlDbType.VarChar, 255), new MySqlParameter("@PointPosition", MySqlDbType.Int32, 10), new MySqlParameter("@DataSource", MySqlDbType.VarChar, 10), new MySqlParameter("@Visibility", MySqlDbType.VarChar, 50), new MySqlParameter("@Sdate", MySqlDbType.VarChar, 255), new MySqlParameter("@Mdate", MySqlDbType.VarChar, 255), new MySqlParameter("@Manhole_Type", MySqlDbType.VarChar, 10), new MySqlParameter("@status", MySqlDbType.VarChar, 10), new MySqlParameter("@Note", MySqlDbType.VarChar, 255), new MySqlParameter("@FileName", MySqlDbType.VarChar, 255), new MySqlParameter("@Uploadtime", MySqlDbType.VarChar, 255), new MySqlParameter("@Exp_No", MySqlDbType.VarChar, 100), new MySqlParameter("@ExpNoTime", MySqlDbType.VarChar, 255) }; parameters[0].Value = model.MapCode; parameters[1].Value = model.StormSystem_ID; parameters[2].Value = model.Exp_NoOri; parameters[3].Value = model.Type; parameters[4].Value = model.X; parameters[5].Value = model.Y; parameters[6].Value = model.High; parameters[7].Value = model.WellDeep; parameters[8].Value = model.Offset; parameters[9].Value = model.Feature; parameters[10].Value = model.Subsid; parameters[11].Value = model.Model; parameters[12].Value = model.WellPipes; parameters[13].Value = model.WellShape; parameters[14].Value = model.WellSize; parameters[15].Value = model.WellMaterial; parameters[16].Value = model.WaterDeep; parameters[17].Value = model.MudDeep; parameters[18].Value = model.Inlet_Type; parameters[19].Value = model.OutfallType; parameters[20].Value = model.ReceiveWater; parameters[21].Value = model.Flap; parameters[22].Value = model.Flap_Diameter; parameters[23].Value = model.Flap_TopEle; parameters[24].Value = model.Flap_BotEle; parameters[25].Value = model.Flap_Material; parameters[26].Value = model.Address; parameters[27].Value = model.PointPosition; parameters[28].Value = model.DataSource; parameters[29].Value = model.Visibility; parameters[30].Value = model.Sdate; parameters[31].Value = model.Mdate; parameters[32].Value = model.Manhole_Type; parameters[33].Value = model.status; parameters[34].Value = model.Note; parameters[35].Value = model.FileName; parameters[36].Value = model.Uploadtime; parameters[37].Value = model.Exp_No; parameters[38].Value = model.ExpNoTime; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.cjplpback DataRowToModel(DataRow row) { Maticsoft.Model.cjplpback model = new Maticsoft.Model.cjplpback(); if (row != null) { if (row["MapCode"] != null) { model.MapCode = row["MapCode"].ToString(); } if (row["StormSystem_ID"] != null) { model.StormSystem_ID = row["StormSystem_ID"].ToString(); } if (row["Exp_NoOri"] != null) { model.Exp_NoOri = row["Exp_NoOri"].ToString(); } if (row["Type"] != null) { model.Type = row["Type"].ToString(); } if (row["X"] != null && row["X"].ToString() != "") { model.X = decimal.Parse(row["X"].ToString()); } if (row["Y"] != null && row["Y"].ToString() != "") { model.Y = decimal.Parse(row["Y"].ToString()); } if (row["High"] != null && row["High"].ToString() != "") { model.High = decimal.Parse(row["High"].ToString()); } if (row["WellDeep"] != null && row["WellDeep"].ToString() != "") { model.WellDeep = decimal.Parse(row["WellDeep"].ToString()); } if (row["Offset"] != null) { model.Offset = row["Offset"].ToString(); } if (row["Feature"] != null) { model.Feature = row["Feature"].ToString(); } if (row["Subsid"] != null) { model.Subsid = row["Subsid"].ToString(); } if (row["Model"] != null) { model.Model = row["Model"].ToString(); } if (row["WellPipes"] != null && row["WellPipes"].ToString() != "") { model.WellPipes = int.Parse(row["WellPipes"].ToString()); } if (row["WellShape"] != null) { model.WellShape = row["WellShape"].ToString(); } if (row["WellSize"] != null) { model.WellSize = row["WellSize"].ToString(); } if (row["WellMaterial"] != null) { model.WellMaterial = row["WellMaterial"].ToString(); } if (row["WaterDeep"] != null && row["WaterDeep"].ToString() != "") { model.WaterDeep = decimal.Parse(row["WaterDeep"].ToString()); } if (row["MudDeep"] != null && row["MudDeep"].ToString() != "") { model.MudDeep = decimal.Parse(row["MudDeep"].ToString()); } if (row["Inlet_Type"] != null) { model.Inlet_Type = row["Inlet_Type"].ToString(); } if (row["OutfallType"] != null) { model.OutfallType = row["OutfallType"].ToString(); } if (row["ReceiveWater"] != null) { model.ReceiveWater = row["ReceiveWater"].ToString(); } if (row["Flap"] != null) { model.Flap = row["Flap"].ToString(); } if (row["Flap_Diameter"] != null && row["Flap_Diameter"].ToString() != "") { model.Flap_Diameter = decimal.Parse(row["Flap_Diameter"].ToString()); } if (row["Flap_TopEle"] != null && row["Flap_TopEle"].ToString() != "") { model.Flap_TopEle = decimal.Parse(row["Flap_TopEle"].ToString()); } if (row["Flap_BotEle"] != null && row["Flap_BotEle"].ToString() != "") { model.Flap_BotEle = decimal.Parse(row["Flap_BotEle"].ToString()); } if (row["Flap_Material"] != null) { model.Flap_Material = row["Flap_Material"].ToString(); } if (row["Address"] != null) { model.Address = row["Address"].ToString(); } if (row["PointPosition"] != null && row["PointPosition"].ToString() != "") { model.PointPosition = int.Parse(row["PointPosition"].ToString()); } if (row["DataSource"] != null) { model.DataSource = row["DataSource"].ToString(); } if (row["Visibility"] != null) { model.Visibility = row["Visibility"].ToString(); } if (row["Sdate"] != null) { model.Sdate = row["Sdate"].ToString(); } if (row["Mdate"] != null) { model.Mdate = row["Mdate"].ToString(); } if (row["Manhole_Type"] != null) { model.Manhole_Type = row["Manhole_Type"].ToString(); } if (row["status"] != null) { model.status = row["status"].ToString(); } if (row["Note"] != null) { model.Note = row["Note"].ToString(); } if (row["FileName"] != null) { model.FileName = row["FileName"].ToString(); } if (row["Uploadtime"] != null) { model.Uploadtime = row["Uploadtime"].ToString(); } if (row["Exp_No"] != null) { model.Exp_No = row["Exp_No"].ToString(); } if (row["ExpNoTime"] != null) { model.ExpNoTime = row["ExpNoTime"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.cjplpback model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update cjplpback set "); strSql.Append("MapCode=@MapCode,"); strSql.Append("StormSystem_ID=@StormSystem_ID,"); strSql.Append("Type=@Type,"); strSql.Append("X=@X,"); strSql.Append("Y=@Y,"); strSql.Append("High=@High,"); strSql.Append("WellDeep=@WellDeep,"); strSql.Append("Offset=@Offset,"); strSql.Append("Feature=@Feature,"); strSql.Append("Subsid=@Subsid,"); strSql.Append("Model=@Model,"); strSql.Append("WellPipes=@WellPipes,"); strSql.Append("WellShape=@WellShape,"); strSql.Append("WellSize=@WellSize,"); strSql.Append("WellMaterial=@WellMaterial,"); strSql.Append("WaterDeep=@WaterDeep,"); strSql.Append("MudDeep=@MudDeep,"); strSql.Append("Inlet_Type=@Inlet_Type,"); strSql.Append("OutfallType=@OutfallType,"); strSql.Append("ReceiveWater=@ReceiveWater,"); strSql.Append("Flap=@Flap,"); strSql.Append("Flap_Diameter=@Flap_Diameter,"); strSql.Append("Flap_TopEle=@Flap_TopEle,"); strSql.Append("Flap_BotEle=@Flap_BotEle,"); strSql.Append("Flap_Material=@Flap_Material,"); strSql.Append("Address=@Address,"); strSql.Append("PointPosition=@PointPosition,"); strSql.Append("DataSource=@DataSource,"); strSql.Append("Visibility=@Visibility,"); strSql.Append("Sdate=@Sdate,"); strSql.Append("Mdate=@Mdate,"); strSql.Append("Manhole_Type=@Manhole_Type,"); strSql.Append("status=@status,"); strSql.Append("Note=@Note,"); strSql.Append("FileName=@FileName,"); strSql.Append("Uploadtime=@Uploadtime,"); strSql.Append("Exp_No=@Exp_No,"); strSql.Append("ExpNoTime=@ExpNoTime"); strSql.Append(" where Exp_NoOri=@Exp_NoOri "); MySqlParameter[] parameters = { new MySqlParameter("@MapCode", MySqlDbType.VarChar, 50), new MySqlParameter("@StormSystem_ID", MySqlDbType.VarChar, 100), new MySqlParameter("@Type", MySqlDbType.VarChar, 10), new MySqlParameter("@X", MySqlDbType.Decimal, 10), new MySqlParameter("@Y", MySqlDbType.Decimal, 10), new MySqlParameter("@High", MySqlDbType.Decimal, 10), new MySqlParameter("@WellDeep", MySqlDbType.Decimal, 7), new MySqlParameter("@Offset", MySqlDbType.VarChar, 255), new MySqlParameter("@Feature", MySqlDbType.VarChar, 255), new MySqlParameter("@Subsid", MySqlDbType.VarChar, 255), new MySqlParameter("@Model", MySqlDbType.VarChar, 255), new MySqlParameter("@WellPipes", MySqlDbType.Int32, 10), new MySqlParameter("@WellShape", MySqlDbType.VarChar, 50), new MySqlParameter("@WellSize", MySqlDbType.VarChar, 150), new MySqlParameter("@WellMaterial", MySqlDbType.VarChar, 255), new MySqlParameter("@WaterDeep", MySqlDbType.Decimal, 10), new MySqlParameter("@MudDeep", MySqlDbType.Decimal, 10), new MySqlParameter("@Inlet_Type", MySqlDbType.VarChar, 10), new MySqlParameter("@OutfallType", MySqlDbType.VarChar, 10), new MySqlParameter("@ReceiveWater", MySqlDbType.VarChar, 255), new MySqlParameter("@Flap", MySqlDbType.VarChar, 10), new MySqlParameter("@Flap_Diameter", MySqlDbType.Decimal, 10), new MySqlParameter("@Flap_TopEle", MySqlDbType.Decimal, 10), new MySqlParameter("@Flap_BotEle", MySqlDbType.Decimal, 10), new MySqlParameter("@Flap_Material", MySqlDbType.VarChar, 255), new MySqlParameter("@Address", MySqlDbType.VarChar, 255), new MySqlParameter("@PointPosition", MySqlDbType.Int32, 10), new MySqlParameter("@DataSource", MySqlDbType.VarChar, 10), new MySqlParameter("@Visibility", MySqlDbType.VarChar, 50), new MySqlParameter("@Sdate", MySqlDbType.VarChar, 255), new MySqlParameter("@Mdate", MySqlDbType.VarChar, 255), new MySqlParameter("@Manhole_Type", MySqlDbType.VarChar, 10), new MySqlParameter("@status", MySqlDbType.VarChar, 10), new MySqlParameter("@Note", MySqlDbType.VarChar, 255), new MySqlParameter("@FileName", MySqlDbType.VarChar, 255), new MySqlParameter("@Uploadtime", MySqlDbType.VarChar, 255), new MySqlParameter("@Exp_No", MySqlDbType.VarChar, 100), new MySqlParameter("@ExpNoTime", MySqlDbType.VarChar, 255), new MySqlParameter("@Exp_NoOri", MySqlDbType.VarChar, 255) }; parameters[0].Value = model.MapCode; parameters[1].Value = model.StormSystem_ID; parameters[2].Value = model.Type; parameters[3].Value = model.X; parameters[4].Value = model.Y; parameters[5].Value = model.High; parameters[6].Value = model.WellDeep; parameters[7].Value = model.Offset; parameters[8].Value = model.Feature; parameters[9].Value = model.Subsid; parameters[10].Value = model.Model; parameters[11].Value = model.WellPipes; parameters[12].Value = model.WellShape; parameters[13].Value = model.WellSize; parameters[14].Value = model.WellMaterial; parameters[15].Value = model.WaterDeep; parameters[16].Value = model.MudDeep; parameters[17].Value = model.Inlet_Type; parameters[18].Value = model.OutfallType; parameters[19].Value = model.ReceiveWater; parameters[20].Value = model.Flap; parameters[21].Value = model.Flap_Diameter; parameters[22].Value = model.Flap_TopEle; parameters[23].Value = model.Flap_BotEle; parameters[24].Value = model.Flap_Material; parameters[25].Value = model.Address; parameters[26].Value = model.PointPosition; parameters[27].Value = model.DataSource; parameters[28].Value = model.Visibility; parameters[29].Value = model.Sdate; parameters[30].Value = model.Mdate; parameters[31].Value = model.Manhole_Type; parameters[32].Value = model.status; parameters[33].Value = model.Note; parameters[34].Value = model.FileName; parameters[35].Value = model.Uploadtime; parameters[36].Value = model.Exp_No; parameters[37].Value = model.ExpNoTime; parameters[38].Value = model.Exp_NoOri; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }