/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(IPSP.Model.TCode_City model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TCode_City set ");
strSql.Append("s_CityName=@s_CityName,");
strSql.Append("s_OCityName=@s_OCityName,");
strSql.Append("s_TelAreaCode=@s_TelAreaCode,");
strSql.Append("s_ZipCode=@s_ZipCode,");
strSql.Append("s_RegionCode=@s_RegionCode");
strSql.Append(" where n_CityID=@n_CityID");
SqlParameter[] parameters =
{
new SqlParameter("@s_CityName", SqlDbType.NVarChar, 100),
new SqlParameter("@s_OCityName", SqlDbType.NVarChar, 100),
new SqlParameter("@s_TelAreaCode", SqlDbType.NVarChar, 50),
new SqlParameter("@s_ZipCode", SqlDbType.NVarChar, 50),
new SqlParameter("@s_RegionCode", SqlDbType.NVarChar, 100),
new SqlParameter("@n_CityID", SqlDbType.Int, 4),
new SqlParameter("@n_StateID", SqlDbType.Int, 4)
};
parameters[0].Value = model.s_CityName;
parameters[1].Value = model.s_OCityName;
parameters[2].Value = model.s_TelAreaCode;
parameters[3].Value = model.s_ZipCode;
parameters[4].Value = model.s_RegionCode;
parameters[5].Value = model.n_CityID;
parameters[6].Value = model.n_StateID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(IPSP.Model.TCode_City model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TCode_City(");
strSql.Append("n_StateID,s_CityName,s_OCityName,s_TelAreaCode,s_ZipCode,s_RegionCode)");
strSql.Append(" values (");
strSql.Append("@n_StateID,@s_CityName,@s_OCityName,@s_TelAreaCode,@s_ZipCode,@s_RegionCode)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@n_StateID", SqlDbType.Int, 4),
new SqlParameter("@s_CityName", SqlDbType.NVarChar, 100),
new SqlParameter("@s_OCityName", SqlDbType.NVarChar, 100),
new SqlParameter("@s_TelAreaCode", SqlDbType.NVarChar, 50),
new SqlParameter("@s_ZipCode", SqlDbType.NVarChar, 50),
new SqlParameter("@s_RegionCode", SqlDbType.NVarChar, 100)
};
parameters[0].Value = model.n_StateID;
parameters[1].Value = model.s_CityName;
parameters[2].Value = model.s_OCityName;
parameters[3].Value = model.s_TelAreaCode;
parameters[4].Value = model.s_ZipCode;
parameters[5].Value = model.s_RegionCode;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public IPSP.Model.TCode_City DataRowToModel(DataRow row)
{
IPSP.Model.TCode_City model = new IPSP.Model.TCode_City();
if (row != null)
{
if (row["n_CityID"] != null && row["n_CityID"].ToString() != "")
{
model.n_CityID = int.Parse(row["n_CityID"].ToString());
}
if (row["n_StateID"] != null && row["n_StateID"].ToString() != "")
{
model.n_StateID = int.Parse(row["n_StateID"].ToString());
}
if (row["s_CityName"] != null)
{
model.s_CityName = row["s_CityName"].ToString();
}
if (row["s_OCityName"] != null)
{
model.s_OCityName = row["s_OCityName"].ToString();
}
if (row["s_TelAreaCode"] != null)
{
model.s_TelAreaCode = row["s_TelAreaCode"].ToString();
}
if (row["s_ZipCode"] != null)
{
model.s_ZipCode = row["s_ZipCode"].ToString();
}
if (row["s_RegionCode"] != null)
{
model.s_RegionCode = row["s_RegionCode"].ToString();
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public IPSP.Model.TCode_City GetModel(int n_CityID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 n_CityID,n_StateID,s_CityName,s_OCityName,s_TelAreaCode,s_ZipCode,s_RegionCode from TCode_City ");
strSql.Append(" where n_CityID=@n_CityID");
SqlParameter[] parameters =
{
new SqlParameter("@n_CityID", SqlDbType.Int, 4)
};
parameters[0].Value = n_CityID;
IPSP.Model.TCode_City model = new IPSP.Model.TCode_City();
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(IPSP.Model.TCode_City model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(IPSP.Model.TCode_City model)
{
return(dal.Add(model));
}
