/// <summary>
/// 执行插入人员信息方法
/// </summary>
/// <param name="obj"></param>
/// <returns>影响行数</returns>
public int Insert(area_info obj)
{
try
{
string sql = "insert into fimp.area_info(area_name_en,area_name_tw,area_name_cn,time_zone )values('{0}','{1}','{2}',{3})";
sql = string.Format(sql, obj.area_name_en, obj.area_name_tw, obj.area_name_cn, obj.time_zone);
int count = PostgreHelper.ExecuteNonQuery(sql);
return(count);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 更新信息
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public int Update(area_info obj)
{
try
{
int count = 0;
string sql = "update fimp.area_info set area_name_en='{0}',area_name_tw='{1}',area_name_cn='{2}',time_zone='{3}' where area_id={4}";
sql = string.Format(sql, obj.area_name_en, obj.area_name_tw, obj.area_name_cn, obj.time_zone, obj.area_id);
count = PostgreHelper.ExecuteNonQuery(sql);
return(count);
}
catch (Exception ex)
{
throw ex;
}
}
public area_info SelectSingleID(int area_id)
{
try
{
area_info obj = new area_info();
string sql = "select * from fimp.area_info where area_id={0}";
sql = string.Format(sql, area_id);
obj = PostgreHelper.GetSingleEntity <area_info>(sql);
return(obj);
}
catch (Exception ex)
{
throw ex;
}
}
public int Update(area_info obj)
{
int count = AIS.Update(obj);
return(count);
}
public int Insert(area_info obj)
{
int count = AIS.Insert(obj);
return(count);
}
public area_info SelectSingleID(int id)
{
area_info obj = AIS.SelectSingleID(id);
return(obj);
}