/// <summary>
/// 得到一个对象实体
/// </summary>
public GroupObjEntity GetModel(int Gp_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Gp_ID,Gp_Code,Gp_Name,Gp_sys_title,Gp_sys_title_vice,Gp_introduction,Gp_size,Gp_map,Gp_map_size,Gp_map_icon_width,Gp_map_icon_height,Gp_map_icon_color,Gp_map_icon_bg_color,Gp_longitude_center,Gp_dimensionality_center,Gp_longitude_east,Gp_longitude_west,Gp_dimensionality_south,Gp_dimensionality_north,Gp_user_number,Gp_well_number,Gp_DTU_number,Gp_card_number,Gp_card_password,Gp_polling_interval,Gp_store_interval,Gp_PID,GP_Map_Level,GP_MapLine_Color,GP_MapLine_Width,GP_Map_Opacity,Gp_SysName,Gp_IrrigateName,Remote_password from GroupObj ");
strSql.Append(" where Gp_ID=@Gp_ID");
SqlParameter[] parameters =
{
new SqlParameter("@Gp_ID", SqlDbType.Int, 4)
};
parameters[0].Value = Gp_ID;
GroupObjEntity model = new GroupObjEntity();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(GroupObjEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into GroupObj(");
strSql.Append("Gp_Code,Gp_Name,Gp_sys_title,Gp_sys_title_vice,Gp_introduction,Gp_size,Gp_map,Gp_map_size,Gp_map_icon_width,Gp_map_icon_height,Gp_map_icon_color,Gp_map_icon_bg_color,Gp_longitude_center,Gp_dimensionality_center,Gp_longitude_east,Gp_longitude_west,Gp_dimensionality_south,Gp_dimensionality_north,Gp_user_number,Gp_well_number,Gp_DTU_number,Gp_card_number,Gp_card_password,Gp_polling_interval,Gp_store_interval,Gp_PID,GP_Map_Level,GP_MapLine_Color,GP_MapLine_Width,GP_Map_Opacity,Gp_SysName,Gp_IrrigateName,Remote_password)");
strSql.Append(" values (");
strSql.Append("@Gp_Code,@Gp_Name,@Gp_sys_title,@Gp_sys_title_vice,@Gp_introduction,@Gp_size,@Gp_map,@Gp_map_size,@Gp_map_icon_width,@Gp_map_icon_height,@Gp_map_icon_color,@Gp_map_icon_bg_color,@Gp_longitude_center,@Gp_dimensionality_center,@Gp_longitude_east,@Gp_longitude_west,@Gp_dimensionality_south,@Gp_dimensionality_north,@Gp_user_number,@Gp_well_number,@Gp_DTU_number,@Gp_card_number,@Gp_card_password,@Gp_polling_interval,@Gp_store_interval,@Gp_PID,@GP_Map_Level,@GP_MapLine_Color,@GP_MapLine_Width,@GP_Map_Opacity,@Gp_SysName,@Gp_IrrigateName,@Remote_password)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Gp_Code", SqlDbType.NVarChar, 50),
new SqlParameter("@Gp_Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Gp_sys_title", SqlDbType.NVarChar, 2000),
new SqlParameter("@Gp_sys_title_vice", SqlDbType.NVarChar, 2000),
new SqlParameter("@Gp_introduction", SqlDbType.NText),
new SqlParameter("@Gp_size", SqlDbType.NVarChar, 50),
new SqlParameter("@Gp_map", SqlDbType.NVarChar, 50),
new SqlParameter("@Gp_map_size", SqlDbType.Int, 4),
new SqlParameter("@Gp_map_icon_width", SqlDbType.Int, 4),
new SqlParameter("@Gp_map_icon_height", SqlDbType.Int, 4),
new SqlParameter("@Gp_map_icon_color", SqlDbType.NVarChar, 50),
new SqlParameter("@Gp_map_icon_bg_color", SqlDbType.NVarChar, 50),
new SqlParameter("@Gp_longitude_center", SqlDbType.Float, 8),
new SqlParameter("@Gp_dimensionality_center", SqlDbType.Float, 8),
new SqlParameter("@Gp_longitude_east", SqlDbType.Float, 8),
new SqlParameter("@Gp_longitude_west", SqlDbType.Float, 8),
new SqlParameter("@Gp_dimensionality_south", SqlDbType.Float, 8),
new SqlParameter("@Gp_dimensionality_north", SqlDbType.Float, 8),
new SqlParameter("@Gp_user_number", SqlDbType.Int, 4),
new SqlParameter("@Gp_well_number", SqlDbType.Int, 4),
new SqlParameter("@Gp_DTU_number", SqlDbType.Int, 4),
new SqlParameter("@Gp_card_number", SqlDbType.Int, 4),
new SqlParameter("@Gp_card_password", SqlDbType.Int, 4),
new SqlParameter("@Gp_polling_interval", SqlDbType.Int, 4),
new SqlParameter("@Gp_store_interval", SqlDbType.Int, 4),
new SqlParameter("@Gp_PID", SqlDbType.Int, 4),
new SqlParameter("@GP_Map_Level", SqlDbType.Int, 4),
new SqlParameter("@GP_MapLine_Color", SqlDbType.Int, 4),
new SqlParameter("@GP_MapLine_Width", SqlDbType.Int, 4),
new SqlParameter("@GP_Map_Opacity", SqlDbType.Float, 8),
new SqlParameter("@Gp_SysName", SqlDbType.NVarChar, 50),
new SqlParameter("@Gp_IrrigateName", SqlDbType.NVarChar, 50),
new SqlParameter("@Remote_password", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.Gp_Code;
parameters[1].Value = model.Gp_Name;
parameters[2].Value = model.Gp_sys_title;
parameters[3].Value = model.Gp_sys_title_vice;
parameters[4].Value = model.Gp_introduction;
parameters[5].Value = model.Gp_size;
parameters[6].Value = model.Gp_map;
parameters[7].Value = model.Gp_map_size;
parameters[8].Value = model.Gp_map_icon_width;
parameters[9].Value = model.Gp_map_icon_height;
parameters[10].Value = model.Gp_map_icon_color;
parameters[11].Value = model.Gp_map_icon_bg_color;
parameters[12].Value = model.Gp_longitude_center;
parameters[13].Value = model.Gp_dimensionality_center;
parameters[14].Value = model.Gp_longitude_east;
parameters[15].Value = model.Gp_longitude_west;
parameters[16].Value = model.Gp_dimensionality_south;
parameters[17].Value = model.Gp_dimensionality_north;
parameters[18].Value = model.Gp_user_number;
parameters[19].Value = model.Gp_well_number;
parameters[20].Value = model.Gp_DTU_number;
parameters[21].Value = model.Gp_card_number;
parameters[22].Value = model.Gp_card_password;
parameters[23].Value = model.Gp_polling_interval;
parameters[24].Value = model.Gp_store_interval;
parameters[25].Value = model.Gp_PID;
parameters[26].Value = model.GP_Map_Level;
parameters[27].Value = model.GP_MapLine_Color;
parameters[28].Value = model.GP_MapLine_Width;
parameters[29].Value = model.GP_Map_Opacity;
parameters[30].Value = model.Gp_SysName;
parameters[31].Value = model.Gp_IrrigateName;
parameters[32].Value = model.Remote_password;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public GroupObjEntity DataRowToModel(DataRow row)
{
GroupObjEntity model = new GroupObjEntity();
if (row != null)
{
if (row["Gp_ID"] != null && row["Gp_ID"].ToString() != "")
{
model.Gp_ID = int.Parse(row["Gp_ID"].ToString());
}
if (row["Gp_Code"] != null)
{
model.Gp_Code = row["Gp_Code"].ToString();
}
if (row["Gp_Name"] != null)
{
model.Gp_Name = row["Gp_Name"].ToString();
}
if (row["Gp_sys_title"] != null)
{
model.Gp_sys_title = row["Gp_sys_title"].ToString();
}
if (row["Gp_sys_title_vice"] != null)
{
model.Gp_sys_title_vice = row["Gp_sys_title_vice"].ToString();
}
if (row["Gp_introduction"] != null)
{
model.Gp_introduction = row["Gp_introduction"].ToString();
}
if (row["Gp_size"] != null)
{
model.Gp_size = row["Gp_size"].ToString();
}
if (row["Gp_map"] != null)
{
model.Gp_map = row["Gp_map"].ToString();
}
if (row["Gp_map_size"] != null && row["Gp_map_size"].ToString() != "")
{
model.Gp_map_size = int.Parse(row["Gp_map_size"].ToString());
}
if (row["Gp_map_icon_width"] != null && row["Gp_map_icon_width"].ToString() != "")
{
model.Gp_map_icon_width = int.Parse(row["Gp_map_icon_width"].ToString());
}
if (row["Gp_map_icon_height"] != null && row["Gp_map_icon_height"].ToString() != "")
{
model.Gp_map_icon_height = int.Parse(row["Gp_map_icon_height"].ToString());
}
if (row["Gp_map_icon_color"] != null)
{
model.Gp_map_icon_color = row["Gp_map_icon_color"].ToString();
}
if (row["Gp_map_icon_bg_color"] != null)
{
model.Gp_map_icon_bg_color = row["Gp_map_icon_bg_color"].ToString();
}
if (row["Gp_longitude_center"] != null && row["Gp_longitude_center"].ToString() != "")
{
model.Gp_longitude_center = decimal.Parse(row["Gp_longitude_center"].ToString());
}
if (row["Gp_dimensionality_center"] != null && row["Gp_dimensionality_center"].ToString() != "")
{
model.Gp_dimensionality_center = decimal.Parse(row["Gp_dimensionality_center"].ToString());
}
if (row["Gp_longitude_east"] != null && row["Gp_longitude_east"].ToString() != "")
{
model.Gp_longitude_east = decimal.Parse(row["Gp_longitude_east"].ToString());
}
if (row["Gp_longitude_west"] != null && row["Gp_longitude_west"].ToString() != "")
{
model.Gp_longitude_west = decimal.Parse(row["Gp_longitude_west"].ToString());
}
if (row["Gp_dimensionality_south"] != null && row["Gp_dimensionality_south"].ToString() != "")
{
model.Gp_dimensionality_south = decimal.Parse(row["Gp_dimensionality_south"].ToString());
}
if (row["Gp_dimensionality_north"] != null && row["Gp_dimensionality_north"].ToString() != "")
{
model.Gp_dimensionality_north = decimal.Parse(row["Gp_dimensionality_north"].ToString());
}
if (row["Gp_user_number"] != null && row["Gp_user_number"].ToString() != "")
{
model.Gp_user_number = int.Parse(row["Gp_user_number"].ToString());
}
if (row["Gp_well_number"] != null && row["Gp_well_number"].ToString() != "")
{
model.Gp_well_number = int.Parse(row["Gp_well_number"].ToString());
}
if (row["Gp_DTU_number"] != null && row["Gp_DTU_number"].ToString() != "")
{
model.Gp_DTU_number = int.Parse(row["Gp_DTU_number"].ToString());
}
if (row["Gp_card_number"] != null && row["Gp_card_number"].ToString() != "")
{
model.Gp_card_number = int.Parse(row["Gp_card_number"].ToString());
}
if (row["Gp_card_password"] != null && row["Gp_card_password"].ToString() != "")
{
model.Gp_card_password = int.Parse(row["Gp_card_password"].ToString());
}
if (row["Gp_polling_interval"] != null && row["Gp_polling_interval"].ToString() != "")
{
model.Gp_polling_interval = int.Parse(row["Gp_polling_interval"].ToString());
}
if (row["Gp_store_interval"] != null && row["Gp_store_interval"].ToString() != "")
{
model.Gp_store_interval = int.Parse(row["Gp_store_interval"].ToString());
}
if (row["Gp_PID"] != null && row["Gp_PID"].ToString() != "")
{
model.Gp_PID = int.Parse(row["Gp_PID"].ToString());
}
if (row["GP_Map_Level"] != null && row["GP_Map_Level"].ToString() != "")
{
model.GP_Map_Level = int.Parse(row["GP_Map_Level"].ToString());
}
if (row["GP_MapLine_Color"] != null && row["GP_MapLine_Color"].ToString() != "")
{
model.GP_MapLine_Color = int.Parse(row["GP_MapLine_Color"].ToString());
}
if (row["GP_MapLine_Width"] != null && row["GP_MapLine_Width"].ToString() != "")
{
model.GP_MapLine_Width = int.Parse(row["GP_MapLine_Width"].ToString());
}
if (row["GP_Map_Opacity"] != null && row["GP_Map_Opacity"].ToString() != "")
{
model.GP_Map_Opacity = decimal.Parse(row["GP_Map_Opacity"].ToString());
}
if (row["Gp_SysName"] != null)
{
model.Gp_SysName = row["Gp_SysName"].ToString();
}
if (row["Gp_IrrigateName"] != null)
{
model.Gp_IrrigateName = row["Gp_IrrigateName"].ToString();
}
if (row["Remote_password"] != null)
{
model.Remote_password = row["Remote_password"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(GroupObjEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update GroupObj set ");
strSql.Append("Gp_Code=@Gp_Code,");
strSql.Append("Gp_Name=@Gp_Name,");
strSql.Append("Gp_sys_title=@Gp_sys_title,");
strSql.Append("Gp_sys_title_vice=@Gp_sys_title_vice,");
strSql.Append("Gp_introduction=@Gp_introduction,");
strSql.Append("Gp_size=@Gp_size,");
strSql.Append("Gp_map=@Gp_map,");
strSql.Append("Gp_map_size=@Gp_map_size,");
strSql.Append("Gp_map_icon_width=@Gp_map_icon_width,");
strSql.Append("Gp_map_icon_height=@Gp_map_icon_height,");
strSql.Append("Gp_map_icon_color=@Gp_map_icon_color,");
strSql.Append("Gp_map_icon_bg_color=@Gp_map_icon_bg_color,");
strSql.Append("Gp_longitude_center=@Gp_longitude_center,");
strSql.Append("Gp_dimensionality_center=@Gp_dimensionality_center,");
strSql.Append("Gp_longitude_east=@Gp_longitude_east,");
strSql.Append("Gp_longitude_west=@Gp_longitude_west,");
strSql.Append("Gp_dimensionality_south=@Gp_dimensionality_south,");
strSql.Append("Gp_dimensionality_north=@Gp_dimensionality_north,");
strSql.Append("Gp_user_number=@Gp_user_number,");
strSql.Append("Gp_well_number=@Gp_well_number,");
strSql.Append("Gp_DTU_number=@Gp_DTU_number,");
strSql.Append("Gp_card_number=@Gp_card_number,");
strSql.Append("Gp_card_password=@Gp_card_password,");
strSql.Append("Gp_polling_interval=@Gp_polling_interval,");
strSql.Append("Gp_store_interval=@Gp_store_interval,");
strSql.Append("Gp_PID=@Gp_PID,");
strSql.Append("GP_Map_Level=@GP_Map_Level,");
strSql.Append("GP_MapLine_Color=@GP_MapLine_Color,");
strSql.Append("GP_MapLine_Width=@GP_MapLine_Width,");
strSql.Append("GP_Map_Opacity=@GP_Map_Opacity,");
strSql.Append("Gp_SysName=@Gp_SysName,");
strSql.Append("Gp_IrrigateName=@Gp_IrrigateName,");
strSql.Append("Remote_password=@Remote_password");
strSql.Append(" where Gp_ID=@Gp_ID");
SqlParameter[] parameters =
{
new SqlParameter("@Gp_Code", SqlDbType.NVarChar, 50),
new SqlParameter("@Gp_Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Gp_sys_title", SqlDbType.NVarChar, 2000),
new SqlParameter("@Gp_sys_title_vice", SqlDbType.NVarChar, 2000),
new SqlParameter("@Gp_introduction", SqlDbType.NText),
new SqlParameter("@Gp_size", SqlDbType.NVarChar, 50),
new SqlParameter("@Gp_map", SqlDbType.NVarChar, 50),
new SqlParameter("@Gp_map_size", SqlDbType.Int, 4),
new SqlParameter("@Gp_map_icon_width", SqlDbType.Int, 4),
new SqlParameter("@Gp_map_icon_height", SqlDbType.Int, 4),
new SqlParameter("@Gp_map_icon_color", SqlDbType.NVarChar, 50),
new SqlParameter("@Gp_map_icon_bg_color", SqlDbType.NVarChar, 50),
new SqlParameter("@Gp_longitude_center", SqlDbType.Float, 8),
new SqlParameter("@Gp_dimensionality_center", SqlDbType.Float, 8),
new SqlParameter("@Gp_longitude_east", SqlDbType.Float, 8),
new SqlParameter("@Gp_longitude_west", SqlDbType.Float, 8),
new SqlParameter("@Gp_dimensionality_south", SqlDbType.Float, 8),
new SqlParameter("@Gp_dimensionality_north", SqlDbType.Float, 8),
new SqlParameter("@Gp_user_number", SqlDbType.Int, 4),
new SqlParameter("@Gp_well_number", SqlDbType.Int, 4),
new SqlParameter("@Gp_DTU_number", SqlDbType.Int, 4),
new SqlParameter("@Gp_card_number", SqlDbType.Int, 4),
new SqlParameter("@Gp_card_password", SqlDbType.Int, 4),
new SqlParameter("@Gp_polling_interval", SqlDbType.Int, 4),
new SqlParameter("@Gp_store_interval", SqlDbType.Int, 4),
new SqlParameter("@Gp_PID", SqlDbType.Int, 4),
new SqlParameter("@GP_Map_Level", SqlDbType.Int, 4),
new SqlParameter("@GP_MapLine_Color", SqlDbType.Int, 4),
new SqlParameter("@GP_MapLine_Width", SqlDbType.Int, 4),
new SqlParameter("@GP_Map_Opacity", SqlDbType.Float, 8),
new SqlParameter("@Gp_SysName", SqlDbType.NVarChar, 50),
new SqlParameter("@Gp_IrrigateName", SqlDbType.NVarChar, 50),
new SqlParameter("@Remote_password", SqlDbType.NVarChar, 50),
new SqlParameter("@Gp_ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.Gp_Code;
parameters[1].Value = model.Gp_Name;
parameters[2].Value = model.Gp_sys_title;
parameters[3].Value = model.Gp_sys_title_vice;
parameters[4].Value = model.Gp_introduction;
parameters[5].Value = model.Gp_size;
parameters[6].Value = model.Gp_map;
parameters[7].Value = model.Gp_map_size;
parameters[8].Value = model.Gp_map_icon_width;
parameters[9].Value = model.Gp_map_icon_height;
parameters[10].Value = model.Gp_map_icon_color;
parameters[11].Value = model.Gp_map_icon_bg_color;
parameters[12].Value = model.Gp_longitude_center;
parameters[13].Value = model.Gp_dimensionality_center;
parameters[14].Value = model.Gp_longitude_east;
parameters[15].Value = model.Gp_longitude_west;
parameters[16].Value = model.Gp_dimensionality_south;
parameters[17].Value = model.Gp_dimensionality_north;
parameters[18].Value = model.Gp_user_number;
parameters[19].Value = model.Gp_well_number;
parameters[20].Value = model.Gp_DTU_number;
parameters[21].Value = model.Gp_card_number;
parameters[22].Value = model.Gp_card_password;
parameters[23].Value = model.Gp_polling_interval;
parameters[24].Value = model.Gp_store_interval;
parameters[25].Value = model.Gp_PID;
parameters[26].Value = model.GP_Map_Level;
parameters[27].Value = model.GP_MapLine_Color;
parameters[28].Value = model.GP_MapLine_Width;
parameters[29].Value = model.GP_Map_Opacity;
parameters[30].Value = model.Gp_SysName;
parameters[31].Value = model.Gp_IrrigateName;
parameters[32].Value = model.Remote_password;
parameters[33].Value = model.Gp_ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(GroupObjEntity model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(GroupObjEntity model)
{
return(dal.Add(model));
}
