//插入数据
public int Insert(line_info obj)
{
try
{
//string sql = "Insert into fimp.line_info(plant_id,dept_id,unit_no,line_name_en,line_name_tw,line_name_cn,story,status_no)values({0},-1,'{1}','{2}',N'{3}',N'{4}',N'{5}','{6}')";
//sql = string.Format(sql, obj.plant_id, obj.unit_no, obj.line_name_en, obj.line_name_tw, obj.line_name_cn, obj.story, obj.status_no);
int count = PostgreHelper.InsertSingleEntity <line_info>(obj);
return(count);
}
catch (Exception ex)
{
throw ex;
}
}
//更新数据
public int Update(line_info obj)
{
try
{
string sql = "Update fimp.line_info set plant_id='{0}',unit_no='{1}',line_name_en='{2}',line_name_tw=N'{3}',line_name_cn=N'{4}',story=N'{5}',status_no='{6}' where line_id={7}";
sql = string.Format(sql, obj.plant_id, obj.unit_no, obj.line_name_en, obj.line_name_tw, obj.line_name_cn, obj.story, obj.status_no, obj.line_id);
int count = PostgreHelper.ExecuteNonQuery(sql);
return(count);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 通过名称查询单笔数据
/// </summary>
/// <param name="line_name_en"></param>
/// <returns></returns>
public line_info SelectByName(string line_name_en)
{
try
{
line_info obj = new line_info();
string sql = "SELECT plant_id,unit_no,line_id,line_name_en,line_name_tw,line_name_cn,story,status_no FROM fimp.line_info where line_name_en='{0}' order by plant_id,unit_no";
sql = string.Format(sql, line_name_en);
obj = PostgreHelper.GetSingleEntity <line_info>(sql);
return(obj);
}
catch (Exception ex)
{
throw ex;
}
}
public int Update(line_info obj)
{
int count = LIS.Update(obj);
return(count);
}
public int Insert(line_info obj)
{
int count = LIS.Insert(obj);
return(count);
}
public line_info SelectSingle(int id)
{
line_info obj = LIS.SelectSingle(id);
return(obj);
}
