/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Sys_SysAreaCity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Sys_SysAreaCity set ");
strSql.Append(" ParentID = @ParentID , ");
strSql.Append(" Sort = @Sort , ");
strSql.Append(" ParentName = @ParentName , ");
strSql.Append(" CityID = @CityID , ");
strSql.Append(" CityName = @CityName , ");
strSql.Append(" PYM = @PYM , ");
strSql.Append(" EnName = @EnName , ");
strSql.Append(" PostCode = @PostCode , ");
strSql.Append(" AreaCode = @AreaCode , ");
strSql.Append(" CName = @CName ");
strSql.Append(" where ParentID=@ParentID and ParentName=@ParentName and CityID=@CityID and CityName=@CityName and PYM=@PYM and EnName=@EnName and PostCode=@PostCode and AreaCode=@AreaCode and CName=@CName and Sort=@Sort ");
int row = DapperHelper.Execute(strSql.ToString(), model);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 新增加一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(Sys_SysAreaCity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Sys_SysAreaCity(");
strSql.Append("ParentID,Sort,ParentName,CityID,CityName,PYM,EnName,PostCode,AreaCode,CName");
strSql.Append(") values (");
strSql.Append("@ParentID,@Sort,@ParentName,@CityID,@CityName,@PYM,@EnName,@PostCode,@AreaCode,@CName");
strSql.Append(") ");
object obj = DapperHelper.ExecuteScalar(strSql.ToString(), model);
if (obj != null)
{
return(Convert.ToInt32(obj));
}
else
{
return(0);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public static bool Update(Sys_SysAreaCity model)
{
Sys_SysAreaCityBaseDAL dal = new Sys_SysAreaCityBaseDAL();
return(dal.Update(model));
}
/// <summary>
/// 新增加一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int Add(Sys_SysAreaCity model)
{
Sys_SysAreaCityBaseDAL dal = new Sys_SysAreaCityBaseDAL();
return(dal.Add(model));
}
