/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(PumpEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Pump set ");
strSql.Append("Pump_Name=@Pump_Name,");
strSql.Append("Pump_longitude=@Pump_longitude,");
strSql.Append("Pump_dimensionality=@Pump_dimensionality,");
strSql.Append("Pump_Description=@Pump_Description,");
strSql.Append("Pump_area=@Pump_area,");
strSql.Append("Msc_ID=@Msc_ID,");
strSql.Append("Pump_Brand=@Pump_Brand,");
strSql.Append("Pump_Specification=@Pump_Specification,");
strSql.Append("Pump_Power=@Pump_Power,");
strSql.Append("Pump_Flow=@Pump_Flow,");
strSql.Append("Pump_Diameter=@Pump_Diameter,");
strSql.Append("Pump_Manufacturer=@Pump_Manufacturer");
strSql.Append(" where Pump_ID=@Pump_ID");
SqlParameter[] parameters =
{
new SqlParameter("@Pump_Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Pump_longitude", SqlDbType.Float, 8),
new SqlParameter("@Pump_dimensionality", SqlDbType.Float, 8),
new SqlParameter("@Pump_Description", SqlDbType.NVarChar, 50),
new SqlParameter("@Pump_area", SqlDbType.NVarChar, 50),
new SqlParameter("@Msc_ID", SqlDbType.Int, 4),
new SqlParameter("@Pump_Brand", SqlDbType.NVarChar, 50),
new SqlParameter("@Pump_Specification", SqlDbType.NVarChar, 150),
new SqlParameter("@Pump_Power", SqlDbType.NVarChar, 50),
new SqlParameter("@Pump_Flow", SqlDbType.NVarChar, 50),
new SqlParameter("@Pump_Diameter", SqlDbType.NChar, 10),
new SqlParameter("@Pump_Manufacturer", SqlDbType.NChar, 10),
new SqlParameter("@Pump_ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.Pump_Name;
parameters[1].Value = model.Pump_longitude;
parameters[2].Value = model.Pump_dimensionality;
parameters[3].Value = model.Pump_Description;
parameters[4].Value = model.Pump_area;
parameters[5].Value = model.Msc_ID;
parameters[6].Value = model.Pump_Brand;
parameters[7].Value = model.Pump_Specification;
parameters[8].Value = model.Pump_Power;
parameters[9].Value = model.Pump_Flow;
parameters[10].Value = model.Pump_Diameter;
parameters[11].Value = model.Pump_Manufacturer;
parameters[12].Value = model.Pump_ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(PumpEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Pump(");
strSql.Append("Pump_Name,Pump_longitude,Pump_dimensionality,Pump_Description,Pump_area,Msc_ID,Pump_Brand,Pump_Specification,Pump_Power,Pump_Flow,Pump_Diameter,Pump_Manufacturer)");
strSql.Append(" values (");
strSql.Append("@Pump_Name,@Pump_longitude,@Pump_dimensionality,@Pump_Description,@Pump_area,@Msc_ID,@Pump_Brand,@Pump_Specification,@Pump_Power,@Pump_Flow,@Pump_Diameter,@Pump_Manufacturer)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Pump_Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Pump_longitude", SqlDbType.Float, 8),
new SqlParameter("@Pump_dimensionality", SqlDbType.Float, 8),
new SqlParameter("@Pump_Description", SqlDbType.NVarChar, 50),
new SqlParameter("@Pump_area", SqlDbType.NVarChar, 50),
new SqlParameter("@Msc_ID", SqlDbType.Int, 4),
new SqlParameter("@Pump_Brand", SqlDbType.NVarChar, 50),
new SqlParameter("@Pump_Specification", SqlDbType.NVarChar, 150),
new SqlParameter("@Pump_Power", SqlDbType.NVarChar, 50),
new SqlParameter("@Pump_Flow", SqlDbType.NVarChar, 50),
new SqlParameter("@Pump_Diameter", SqlDbType.NChar, 10),
new SqlParameter("@Pump_Manufacturer", SqlDbType.NChar, 10)
};
parameters[0].Value = model.Pump_Name;
parameters[1].Value = model.Pump_longitude;
parameters[2].Value = model.Pump_dimensionality;
parameters[3].Value = model.Pump_Description;
parameters[4].Value = model.Pump_area;
parameters[5].Value = model.Msc_ID;
parameters[6].Value = model.Pump_Brand;
parameters[7].Value = model.Pump_Specification;
parameters[8].Value = model.Pump_Power;
parameters[9].Value = model.Pump_Flow;
parameters[10].Value = model.Pump_Diameter;
parameters[11].Value = model.Pump_Manufacturer;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public PumpEntity GetModel(int Pump_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Pump_ID,Pump_Name,Pump_longitude,Pump_dimensionality,Pump_Description,Pump_area,Msc_ID,Pump_Brand,Pump_Specification,Pump_Power,Pump_Flow,Pump_Diameter,Pump_Manufacturer from Pump ");
strSql.Append(" where Pump_ID=@Pump_ID");
SqlParameter[] parameters =
{
new SqlParameter("@Pump_ID", SqlDbType.Int, 4)
};
parameters[0].Value = Pump_ID;
PumpEntity model = new PumpEntity();
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 bool Update(PumpEntity model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(PumpEntity model)
{
return(dal.Add(model));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public PumpEntity DataRowToModel(DataRow row)
{
PumpEntity model = new PumpEntity();
if (row != null)
{
if (row["Pump_ID"] != null && row["Pump_ID"].ToString() != "")
{
model.Pump_ID = int.Parse(row["Pump_ID"].ToString());
}
if (row["Pump_Name"] != null)
{
model.Pump_Name = row["Pump_Name"].ToString();
}
if (row["Pump_longitude"] != null && row["Pump_longitude"].ToString() != "")
{
model.Pump_longitude = decimal.Parse(row["Pump_longitude"].ToString());
}
if (row["Pump_dimensionality"] != null && row["Pump_dimensionality"].ToString() != "")
{
model.Pump_dimensionality = decimal.Parse(row["Pump_dimensionality"].ToString());
}
if (row["Pump_Description"] != null)
{
model.Pump_Description = row["Pump_Description"].ToString();
}
if (row["Pump_area"] != null)
{
model.Pump_area = row["Pump_area"].ToString();
}
if (row["Msc_ID"] != null && row["Msc_ID"].ToString() != "")
{
model.Msc_ID = int.Parse(row["Msc_ID"].ToString());
}
if (row["Pump_Brand"] != null)
{
model.Pump_Brand = row["Pump_Brand"].ToString();
}
if (row["Pump_Specification"] != null)
{
model.Pump_Specification = row["Pump_Specification"].ToString();
}
if (row["Pump_Power"] != null)
{
model.Pump_Power = row["Pump_Power"].ToString();
}
if (row["Pump_Flow"] != null)
{
model.Pump_Flow = row["Pump_Flow"].ToString();
}
if (row["Pump_Diameter"] != null)
{
model.Pump_Diameter = row["Pump_Diameter"].ToString();
}
if (row["Pump_Manufacturer"] != null)
{
model.Pump_Manufacturer = row["Pump_Manufacturer"].ToString();
}
}
return(model);
}