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