/// <summary>
/// 增加一条数据
/// </summary>
public void Add(CardCenter.Entity.Para_Department model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Para_Department(");
strSql.Append("ID,City,Area,GS,ZJ,SW,HG,WJ,WH)");
strSql.Append(" values (");
strSql.Append("@ID,@City,@Area,@GS,@ZJ,@SW,@HG,@WJ,@WH)");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.NVarChar, 6),
new SqlParameter("@City", SqlDbType.NVarChar, 64),
new SqlParameter("@Area", SqlDbType.NVarChar, 64),
new SqlParameter("@GS", SqlDbType.NVarChar, 16),
new SqlParameter("@ZJ", SqlDbType.NVarChar, 16),
new SqlParameter("@SW", SqlDbType.NVarChar, 16),
new SqlParameter("@HG", SqlDbType.NVarChar, 16),
new SqlParameter("@WJ", SqlDbType.NVarChar, 16),
new SqlParameter("@WH", SqlDbType.NVarChar, 16)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.City;
parameters[2].Value = model.Area;
parameters[3].Value = model.GS;
parameters[4].Value = model.ZJ;
parameters[5].Value = model.SW;
parameters[6].Value = model.HG;
parameters[7].Value = model.WJ;
parameters[8].Value = model.WH;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public CardCenter.Entity.Para_Department DataRowToModel(DataRow row)
{
CardCenter.Entity.Para_Department model = new CardCenter.Entity.Para_Department();
if (row != null)
{
if (row["ID"] != null)
{
model.ID = row["ID"].ToString();
}
if (row["City"] != null)
{
model.City = row["City"].ToString();
}
if (row["Area"] != null)
{
model.Area = row["Area"].ToString();
}
if (row["GS"] != null)
{
model.GS = row["GS"].ToString();
}
if (row["ZJ"] != null)
{
model.ZJ = row["ZJ"].ToString();
}
if (row["SW"] != null)
{
model.SW = row["SW"].ToString();
}
if (row["HG"] != null)
{
model.HG = row["HG"].ToString();
}
if (row["WJ"] != null)
{
model.WJ = row["WJ"].ToString();
}
if (row["WH"] != null)
{
model.WH = row["WH"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(CardCenter.Entity.Para_Department model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Para_Department set ");
strSql.Append("City=@City,");
strSql.Append("Area=@Area,");
strSql.Append("GS=@GS,");
strSql.Append("ZJ=@ZJ,");
strSql.Append("SW=@SW,");
strSql.Append("HG=@HG,");
strSql.Append("WJ=@WJ,");
strSql.Append("WH=@WH");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@City", SqlDbType.NVarChar, 64),
new SqlParameter("@Area", SqlDbType.NVarChar, 64),
new SqlParameter("@GS", SqlDbType.NVarChar, 16),
new SqlParameter("@ZJ", SqlDbType.NVarChar, 16),
new SqlParameter("@SW", SqlDbType.NVarChar, 16),
new SqlParameter("@HG", SqlDbType.NVarChar, 16),
new SqlParameter("@WJ", SqlDbType.NVarChar, 16),
new SqlParameter("@WH", SqlDbType.NVarChar, 16),
new SqlParameter("@ID", SqlDbType.NVarChar, 6)
};
parameters[0].Value = model.City;
parameters[1].Value = model.Area;
parameters[2].Value = model.GS;
parameters[3].Value = model.ZJ;
parameters[4].Value = model.SW;
parameters[5].Value = model.HG;
parameters[6].Value = model.WJ;
parameters[7].Value = model.WH;
parameters[8].Value = model.ID;
TranHelper.AddTran(strSql, parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public CardCenter.Entity.Para_Department GetModel(string ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,City,Area,GS,ZJ,SW,HG,WJ,WH from Para_Department ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.NVarChar, 6)
};
parameters[0].Value = ID;
CardCenter.Entity.Para_Department model = new CardCenter.Entity.Para_Department();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
