/// <summary>
/// 用于销售管理：模糊查询，查询结果为一笔或多笔数据
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public List <DuiZhang> SelectForInvoice(string dz_start_time, string dz_end_time, string deliver_company_head, string dz_index)
{
try
{
List <DuiZhang> objList = new List <DuiZhang>();
string sql = null;
if (!string.IsNullOrEmpty(deliver_company_head))
{
deliver_company_head = deliver_company_head.Replace("(", "\\(").Replace(")", "\\)");
}
sql = "select a.dz_index,max(a.dui_time) as dui_time,max(a.company_name) as company_name," +
" sum(a.dui_num) as dui_num,sum(a.dui_all_price) as dui_all_price" +
" from jinchen.duizhang_info a, jinchen.sale_info b" +
" where a.sale_id = b.id and company_name ~*'{0}'" +
" and to_char(a.dui_time,'yyyy-MM-dd')>= '{1}' and to_char(a.dui_time,'yyyy-MM-dd')<= '{2}'" +
" and dz_index ~*'{3}'" +
" and a.invoice_time is null" +
" group by a.dz_index" +
" order by a.dz_index desc";
sql = string.Format(sql, deliver_company_head, dz_start_time, dz_end_time, dz_index);
objList = PostgreHelper.GetEntityList <DuiZhang>(sql);
return(objList);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 查询异常配置所关联的机种信息
/// </summary>
/// <param name="config_id">配置id</param>
/// <param name="class_no">班别</param>
/// <param name="part_num">机种编号</param>
/// <returns></returns>
public List <error_config_pn> GetCfgPartNum(int config_id, string class_no = null, string part_num = null)
{
List <error_config_pn> list = new List <error_config_pn>();
string command = string.Empty;
if (config_id > 0 && class_no != null && part_num != null)
{
command = string.Format("Select * from andon.error_config_pn where error_config_id='{0}' and class_no='{1}' and part_num='{2}'", config_id, class_no, part_num);
}
else if (config_id > 0 && class_no != null)
{
command = string.Format("Select * from andon.error_config_pn where error_config_id='{0}' and class_no='{1}'", config_id, class_no);
}
else if (config_id > 0 && part_num != null)
{
command = string.Format("Select * from andon.error_config_pn where error_config_id='{0}'and part_num='{1}'", config_id, part_num);
}
else if (config_id > 0)
{
command = string.Format("Select * from andon.error_config_pn where error_config_id='{0}'", config_id);
}
else
{
command = string.Format("Select * from andon.error_config_pn ");
}
if (command != string.Empty)
{
list = PostgreHelper.GetEntityList <error_config_pn>(command);
}
return(list);
}
/// <summary>
/// 用于销售结款和历史销售结款
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public List <Sale> SelectMoneyAll(string start_time, string end_time, string deliver_index, string deliver_company_head, string order_name, string purchase_person)
{
try
{
List <Sale> objList = new List <Sale>();
string sql = null;
if (!string.IsNullOrEmpty(deliver_company_head))
{
deliver_company_head = deliver_company_head.Replace("(", "\\(").Replace(")", "\\)");
}
sql = "select a.id, b.company_order_index,a.deliver_index,a.deliver_company_head,real_num,deliver_price,deliver_all_price," +
"a.money_way,order_name,unit,purchase_person,a.insert_time,a.seq_id,a.money_onoff,c.tui_num,a.return_flag,a.dz_num " +
" from jinchen.sale_info a,jinchen.order_info b,jinchen.orderseq_info c " +
"where a.order_id=b.id and a.seq_id=c.seq_id and a.order_id=c.order_id and deliver_index ~*'{0}' and deliver_company_head ~*'{1}' and to_char(a.insert_time,'yyyy-MM-dd')>='{2}' and " +
"to_char(a.insert_time,'yyyy-MM-dd')<='{3}' and order_name ~* '{4}' and purchase_person ~* '{5}' and a.flag=0 and c.flag=0 " +
"order by deliver_index desc,deliver_company_head";
sql = string.Format(sql, deliver_index, deliver_company_head, start_time, end_time, order_name, purchase_person);
objList = PostgreHelper.GetEntityList <Sale>(sql);
return(objList);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 用于销售结款和历史销售结款
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public List <DuiZhang> SelectHistory(string deliver_start_time, string deliver_end_time, string dz_start_time, string dz_end_time,
string company_order_index, string company_name, string order_name, string dz_index, string invoice_index, string deliver_index)
{
try
{
List <DuiZhang> objList = new List <DuiZhang>();
string sql = null;
if (!string.IsNullOrEmpty(company_name))
{
company_name = company_name.Replace("(", "\\(").Replace(")", "\\)");
}
sql = "select a.id, a.company_order_index,a.company_name,a.dui_num,a.dui_price,a.dui_all_price," +
"a.order_name,a.unit,a.dz_index,a.invoice_index,a.deliver_time,dui_time,b.deliver_index " +
"from (select * " +
" from jinchen.duizhang_info a " +
"where company_order_index ~*'{0}' and company_name ~*'{1}' and to_char(a.deliver_time,'yyyy-MM-dd')>='{2}' and " +
"to_char(a.deliver_time,'yyyy-MM-dd')<='{3}' and to_char(a.dui_time,'yyyy-MM-dd')>='{4}' and to_char(a.dui_time,'yyyy-MM-dd')<='{5}' and " +
"order_name ~* '{6}' and dz_index ~* '{7}' and invoice_index ~* '{8}' ) a " +
"inner join (select * from jinchen.sale_info) b on a.sale_id=b.id and deliver_index ~* '{9}' " +
"order by a.dui_time desc, b.deliver_index desc,a.company_name";
sql = string.Format(sql, company_order_index, company_name, deliver_start_time, deliver_end_time, dz_start_time, dz_end_time,
order_name, dz_index, invoice_index, deliver_index);
objList = PostgreHelper.GetEntityList <DuiZhang>(sql);
return(objList);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 退单统计数据（待确认和已确认）
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public List <SaleReturn> SelectAll(int return_status, string start_time, string end_time, string return_index, string order_name)
{
try
{
List <SaleReturn> objList = new List <SaleReturn>();
string sql = null;
sql = "select a.return_index,a.return_num,a.return_price,a.return_all_price,a.insert_time,b.deliver_index,c.order_name,c.unit," +
"d.company_order_index,b.deliver_company_head,a.seq_id,a.confirm_time " +
"from jinchen.salereturn_info a,jinchen.sale_info b,jinchen.orderseq_info c,jinchen.order_info d " +
" where a.deliver_index=b.deliver_index and a.seq_id=b.seq_id " +
"and b.seq_id=c.seq_id and b.order_id=c.order_id and c.order_id=d.id and " +
" return_index ~*'{0}' and to_char(a.insert_time,'yyyy-MM-dd') >='{1}' and " +
"to_char(a.insert_time,'yyyy-MM-dd') <='{2}' and return_status={3} and c.order_name ~* '{4}' " +
"order by return_index desc";
sql = string.Format(sql, return_index, start_time, end_time, return_status, order_name);
objList = PostgreHelper.GetEntityList <SaleReturn>(sql);
return(objList);
}
catch (Exception ex)
{
throw ex;
}
}
//查询所有
public List <material_info> SelectAll(string material_name)
{
try
{
List <material_info> objList = new List <material_info>();
string sql = null;
if (string.IsNullOrEmpty(material_name))
{
sql = "SELECT a.id,a.category_id,b.type_name,a.material_code,a.material_name,a.material_type,a.material_inventory,a.remark,a.createtime FROM fimp.material_info a,fimp.material_category b where a.category_id=b.id order by a.material_code, a.material_code";
sql = string.Format(sql);
}
else
{
sql = "SELECT a.id,a.category_id,b.type_name,a.material_code,a.material_name,a.material_type,a.material_inventory,a.remark,a.createtime FROM fimp.material_info a,fimp.material_category b where a.category_id=b.id and a.material_name like '%{0}%' or a.material_code like '%{0}%' order by a.material_code, a.material_code";
sql = string.Format(sql, material_name);
}
objList = PostgreHelper.GetEntityList <material_info>(sql);
return(objList);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 根据名称、税号、账户和开户行对公司模糊查询，查询结果为一笔或多笔数据
/// </summary>
/// <param name="invoice_index"></param>
/// <param name="company_name"></param>
/// <returns></returns>
public List <Invoice> SelectAll(int status, string start_time, string end_time, string confirm_start_time, string confirm_end_time,
string invoice_index, string company_name, string invoice_company)
{
try
{
List <Invoice> objList = new List <Invoice>();
string sql = null;
//if (!string.IsNullOrEmpty(company_name))
//{
// company_name = company_name.Replace("(", "\\(").Replace(")", "\\)");
//}
sql = "select a.id,a.company_name,a.invoice_company,a.invoice_type,a.invoice_index," +
"a.invoice_time,a.invoice_price,a.invoice_real_price,a.invoice_prepay,a.pay_type,a.remark,confirm_time " +
"from jinchen.invoice_info a " +
"where a.invoice_index ~* '{0}' and a.company_name ~* '{1}' and a.status={2} and to_char(invoice_time,'yyyy-MM-dd')>='{3}' " +
"and to_char(invoice_time,'yyyy-MM-dd')<='{4}' and to_char(confirm_time,'yyyy-MM-dd')>='{5}' and to_char(confirm_time,'yyyy-MM-dd')<='{6}' and invoice_company ~* '{7}' " +
"order by a.invoice_time desc";
sql = string.Format(sql, invoice_index, company_name, status, start_time, end_time, confirm_start_time, confirm_end_time, invoice_company);
objList = PostgreHelper.GetEntityList <Invoice>(sql);
return(objList);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 用于订单管理：根据联系人名模糊查询，查询结果为一笔或多笔数据
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public List <Order> SelectAll(int order_status, string start_time, string end_time, string deliver_start_time, string deliver_end_time, string company_name,
string order_index, string company_order_index, string purchase_person, string order_name)
{
try
{
List <Order> objList = new List <Order>();
string sql = null;
if (!string.IsNullOrEmpty(company_name))
{
company_name = company_name.Replace("(", "\\(").Replace(")", "\\)");
}
sql = "select c.id,c.company_order_index,c.order_index,b.company_name,a.order_time,a.order_name,a.deliver_time," +
" order_num,order_price,order_all_price,tui_num, open_num,remain_num,purchase_person,a.seq_id,a.order_picture,a.remark,a.unit " +
"from jinchen.orderseq_info a,jinchen.company_info b,jinchen.order_info c where a.order_id=c.id and c.customer_id=b.id and a.flag=0 and " +
" b.company_name ~* '{0}' and c.order_index ~* '{1}' and c.company_order_index ~*'{2}' and to_char(a.order_time,'yyyy-MM-dd')>='{3}' and to_char(a.order_time,'yyyy-MM-dd')<='{4}' and a.order_status={5} " +
" and to_char(a.deliver_time,'yyyy-MM-dd')>='{6}' and to_char(a.deliver_time,'yyyy-MM-dd')<='{7}' and purchase_person ~*'{8}' and order_name ~*'{9}' " +
" order by a.order_time desc,c.order_index desc,order_name";
sql = string.Format(sql, company_name, order_index, company_order_index, start_time, end_time, order_status, deliver_start_time,
deliver_end_time, purchase_person, order_name);
objList = PostgreHelper.GetEntityList <Order>(sql);
return(objList);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 查询指定时间段内的记录
/// </summary>
/// <param name="start_time">开始时间</param>
/// <param name="end_time">结束时间</param>
/// <param name="device_code">装置编号</param>
/// <returns></returns>
public List <error_log> GetAllLogByTime(DateTime start_time, DateTime end_time, string device_code = null)
{
List <error_log> list = new List <error_log>();
try
{
string sql;
if (string.IsNullOrEmpty(device_code) == false)
{
sql = "select * from andon.error_log where start_time>='{0}' and start_time<='{1}' and machine_code='{2}'";
sql = string.Format(sql, start_time, end_time, device_code);
}
else
{
sql = "select * from andon.error_log where start_time>='{0}' and start_time<='{1}'";
sql = string.Format(sql, start_time, end_time);
}
list = PostgreHelper.GetEntityList <error_log>(sql);
return(list);
}
catch (Exception ex)
{
return(list);
}
}
/// <summary>
/// 查询所有C/T，或者指定设备的
/// </summary>
/// <returns></returns>
public List <CT> SelectAllByWorkOrder(string device_code, string work_order, string pn, string tag_code)
{
try
{
List <CT> objList = new List <CT>();
string comm;
if (string.IsNullOrEmpty(tag_code) == false)
{
comm = "SELECT * FROM fimp.ct where machine_code='{0}' and wo='{1}' and pn='{2}' and tag_code='{3}' order by end_time desc";
comm = string.Format(comm, device_code, work_order, pn, tag_code);
}
else
{
comm = "SELECT * FROM fimp.ct where machine_code='{0}' and wo='{1}' and pn='{2}' order by end_time desc";
comm = string.Format(comm, device_code, work_order, pn);
}
objList = PostgreHelper.GetEntityList <CT>(comm);
return(objList);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(null);
}
public List <error_log_person> GetErrorLogPersonByLogId(int LogId)
{
string command = string.Format("Select * from andon.error_log_person where error_log_id='{0}'", LogId);
var list = PostgreHelper.GetEntityList <error_log_person>(command);
return(list);
}
/// <summary>
/// 用于销售管理：模糊查询，查询结果为一笔或多笔数据
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public List <Sale> SelectAll(string start_time, string end_time, string deliver_index, string deliver_company_head)
{
try
{
List <Sale> objList = new List <Sale>();
string sql = null;
if (!string.IsNullOrEmpty(deliver_company_head))
{
deliver_company_head = deliver_company_head.Replace("(", "\\(").Replace(")", "\\)");
}
sql = "select deliver_index,deliver_company_head,sum(real_num) as real_num,sum(deliver_all_price) as deliver_all_price,max(insert_time) as insert_time " +
"from jinchen.sale_info a " +
"where deliver_index ~*'{0}' and deliver_company_head ~*'{1}' and to_char(insert_time,'yyyy-MM-dd')>='{2}' and to_char(insert_time,'yyyy-MM-dd')<='{3}' and a.flag=0 " +
"group by deliver_index,deliver_company_head order by deliver_index desc";
sql = string.Format(sql, deliver_index, deliver_company_head, start_time, end_time);
objList = PostgreHelper.GetEntityList <Sale>(sql);
return(objList);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 查询入库单中尚未确认结款的单子（物料购入流水账和供应商结款共用一个）
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public List <Purchase> SelectDeliverAll(string start_time, string end_time, string company_name, string purchase_index, string material_name, string deliver_index, string category)
{
try
{
List <Purchase> objList = new List <Purchase>();
string sql = null;
if (!string.IsNullOrEmpty(company_name))
{
company_name = company_name.Replace("(", "\\(").Replace(")", "\\)");
}
sql = "SELECT a.id, b.company_name, a.purchase_index, a.category,a.deliver_index,a.deliver_time, a.material_name, a.material_spec, " +
"a.material_num, a.material_unit, a.material_price, a.material_all_price,money_onoff,money_way,status,confirm_time " +
"FROM jinchen.purchase_info a, jinchen.company_info b " +
" where a.supplier_id = b.id and a.purchase_index ~* '{0}' and b.company_name ~* '{1}' and a.material_name ~* '{2}' and flag=0 and " +
"a.deliver_index ~* '{3}' and a.status =0 and to_char(a.deliver_time,'yyyy-MM-dd')>='{4}' and to_char(a.deliver_time,'yyyy-MM-dd')<='{5}' and a.category ~* '{6}' " +
"order by a.purchase_index desc ";
sql = string.Format(sql, purchase_index, company_name, material_name, deliver_index, start_time, end_time, category);
objList = PostgreHelper.GetEntityList <Purchase>(sql);
return(objList);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 查询订单下的序号，只用于判断该订单下的序号有多少个
/// </summary>
/// <param name="id">用户id</param>
/// <returns></returns>
public List <Order> SelectOrderSeqList(int order_id, string company_name)
{
try
{
List <Order> objList = new List <Order>();
string sql = null;
if (order_id == 0)
{
sql = "select a.id,c.order_id,a.order_index,b.company_name, c.seq_id,c.order_time,c.order_name,c.unit,c.deliver_time," +
"c.order_num,c.open_num,c.tui_num,c.remain_num,c.order_price,c.order_all_price,c.purchase_person,c.remark,a.company_order_index " +
"from jinchen.order_info a,jinchen.company_info b,jinchen.orderseq_info c " +
"where a.customer_id=b.id and a.id=c.order_id and b.company_name='{0}' and c.flag=0 order by c.order_name";
sql = string.Format(sql, company_name);
}
else
{
sql = "select a.id,c.order_id,a.order_index,b.company_name, c.seq_id,c.order_time,c.order_name,c.unit,c.deliver_time," +
"c.order_num,c.open_num,c.tui_num,c.remain_num,c.order_price,c.order_all_price,c.purchase_person,c.remark,a.company_order_index " +
"from jinchen.order_info a,jinchen.company_info b,jinchen.orderseq_info c " +
"where a.customer_id=b.id and a.id=c.order_id and a.id={0} and b.company_name='{1}' and c.flag=0 order by c.order_name";
sql = string.Format(sql, order_id, company_name);
}
objList = PostgreHelper.GetEntityList <Order>(sql);
return(objList);
}
catch (Exception ex)
{
throw ex;
}
}
public List <error_config> SelectAll(int line_id, string unit_no = null, string part_num = null)
{
List <error_config> list = new List <error_config>();
string command = string.Empty;
if (line_id > 0 && unit_no != null && part_num != null)
{
command = string.Format("Select * from andon.error_config where line_id='{0}' and unit_no='{1}' and part_num='{2}' order by id", line_id, unit_no, part_num);
}
else if (line_id > 0 && unit_no != null)
{
command = string.Format("Select * from andon.error_config where line_id='{0}' and unit_no='{1}' order by id", line_id, unit_no);
}
else if (line_id > 0)
{
command = string.Format("Select * from andon.error_config where line_id='{0}' order by id", line_id);
}
else if (unit_no != null)
{
command = string.Format("Select * from andon.error_config where line_id='{0}' and unit_no='{1}' order by id", line_id, unit_no);
}
else
{
command = string.Format("Select * from andon.error_config order by id");
}
if (command != string.Empty)
{
list = PostgreHelper.GetEntityList <error_config>(command);
}
return(list);
}
public List <rest_time_row> SelectAll(string start_time, string end_time)
{
try
{
List <rest_time_row> objList = new List <rest_time_row>();
string sql = null;
if (!string.IsNullOrEmpty(start_time) && !string.IsNullOrEmpty(end_time))
{
sql = "select * from fimp.rest_time_row where start_time>='{0}' and end_time<='{1}' order by start_time desc,machine_code";
sql = string.Format(sql, start_time, end_time);
}
else
{
string sys_time = System.DateTime.Now.AddHours(GlobalDefine.SysTimeZone).ToString("yyyy-MM-dd HH:mm:ss");
sql = "select * from fimp.rest_time_row where end_time>='{0}' order by start_time desc,machine_code";
sql = string.Format(sql, sys_time);
}
objList = PostgreHelper.GetEntityList <rest_time_row>(sql);
return(objList);
//string sql="select * from rest_time_row where "
}
catch (Exception ex)
{
throw ex;
}
}
public List <dept_info> SelectAllid(int id)
{
try
{
List <dept_info> objList = new List <dept_info>();
string sql = null;
if (id > 0)
{
sql = "SELECT * FROM fimp.dept_info where dept_id={0} order by dept_id";
sql = string.Format(sql, id);
}
else
{
sql = "SELECT * FROM fimp.dept_info order by plant_id";
}
objList = PostgreHelper.GetEntityList <dept_info>(sql);
return(objList);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 检查是否已经存在异常
/// </summary>
/// <param name="SysTagCode"></param>
/// <param name="MachineCode"></param>
/// <param name="StationId"></param>
/// <returns></returns>
public bool CheckMaterialRequireExist(String SysTagCode, int MaterialId, string MachineCode = "", int StationId = -1)
{
string sql;
if (StationId > 0)
{
sql = "select * from andon.error_log where station_id={0} and system_tag_code='{1}' and error_type_id='{2}' and (release_time<='2001-01-01 00:00:00' or release_time is null)";
sql = string.Format(sql, StationId, SysTagCode, MaterialId);
}
else
{
sql = "select * from andon.error_log where machine_code='{0}' and system_tag_code='{1}' and error_type_id='{2}' and (release_time<='2001-01-01 00:00:00' or release_time is null)";
sql = string.Format(sql, MachineCode, SysTagCode, MaterialId);
}
var list = PostgreHelper.GetEntityList <error_log>(sql);
if (list == null || list.Count == 0)
{
return(false);
}
else
{
return(true);
}
}
/// <summary>
/// 查找未完成的物料请求
/// </summary>
/// <param name="MaterialId"></param>
/// <param name="StationId"></param>
/// <returns></returns>
public List <material_request_info> SelectUnfinishedRequestInfo(int MaterialId, int StationId)
{
List <material_request_info> list = new List <material_request_info>();
string command = string.Format(" Select * from fimp.material_request_info where material_id='{0}' and station_id='{1}' and (take_time is null or take_time<='2001-01-01 00:00:00')", MaterialId, StationId);
list = PostgreHelper.GetEntityList <material_request_info>(command);
return(list);
}
public List <station_info> SelectAllByUnit(string unit_no)
{
List <station_info> objList = new List <station_info>();
string sql = null;
sql = "select * from fimp.station_info where unit_no='{0}'";
sql = string.Format(sql, unit_no);
objList = PostgreHelper.GetEntityList <station_info>(sql);
return(objList);
}
//判断当前时间是否在班别中，属于哪里班别，班别的开始时间与结束时间
public class_info SelectClass(string date_time, string date)
{
try
{
class_info obj = null;
//转换为时间
string time = Convert.ToDateTime(date_time).ToString("HH:mm:ss");
//查询
string sql = "SELECT * FROM fimp.class_info order by start_time";
List <class_info> objList = PostgreHelper.GetEntityList <class_info>(sql);
foreach (var classItem in objList)
{
string start_time = classItem.start_time;
string end_time = classItem.end_time;
if (Convert.ToDateTime(start_time) > Convert.ToDateTime(end_time))
{
DateTime start_time1 = Convert.ToDateTime("23:59:59");
DateTime end_time1 = Convert.ToDateTime("00:00:00");
if (Convert.ToDateTime(start_time) <= Convert.ToDateTime(time) && Convert.ToDateTime(time) <= Convert.ToDateTime(start_time1))
{
classItem.start_time = date + " " + classItem.start_time;
classItem.end_time = Convert.ToDateTime(date).AddDays(1).ToString("yyyy-MM-dd") + " " + classItem.end_time;
obj = classItem;
break;
}
else if (Convert.ToDateTime(end_time1) <= Convert.ToDateTime(time) && Convert.ToDateTime(time) <= Convert.ToDateTime(end_time))
{
classItem.start_time = date + " " + classItem.start_time;
classItem.end_time = Convert.ToDateTime(date).AddDays(1).ToString("yyyy-MM-dd") + " " + classItem.end_time;
obj = classItem;
break;
}
}
else
{
//获取当前时间对应的班别及时间
if (Convert.ToDateTime(start_time) <= Convert.ToDateTime(time) && Convert.ToDateTime(time) <= Convert.ToDateTime(end_time))
{
classItem.start_time = date + " " + classItem.start_time;
classItem.end_time = date + " " + classItem.end_time;
obj = classItem;
break;
}
}
}
return(obj);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 查询异常配置所关联的人员
/// </summary>
/// <param name="config_id">配置id</param>
/// <returns></returns>
public List <error_config_person> GetCfgPersons(int config_id)
{
List <error_config_person> list = new List <error_config_person>();
string command = string.Empty;
command = string.Format("Select * from andon.error_config_person where error_config_id='{0}'", config_id);
if (command != string.Empty)
{
list = PostgreHelper.GetEntityList <error_config_person>(command);
}
return(list);
}
/// <summary>
/// 查询用户信息列表
/// </summary>
/// <param name="user_name">根据用户名查询，可为空</param>
/// <returns></returns>
public List <material_info> SelectAllcol()
{
try
{
List <material_info> objList = new List <material_info>();
string sql = null;
sql = "select * from fimp.material_info order by id";
objList = PostgreHelper.GetEntityList <material_info>(sql);
return(objList);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取站别信息
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public List <MachineInfo> SelectMachineNameByStaion(int id)
{
try
{
List <MachineInfo> objList = new List <MachineInfo>();
string sql = null;
sql = "SELECT mqtt_no,machine_id,area_id,city_id,plant_id,unit_no,line_id,machine_code,machine_name_en,machine_name_tw,machine_name_cn,status_no,station_id,set_up FROM fimp.machine_info where station_id={0} order by machine_name_cn";
sql = string.Format(sql, id);
objList = PostgreHelper.GetEntityList <MachineInfo>(sql);
return(objList);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 查询单笔数据，通过line
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public List <station_info> SelectByLine(int line_id)
{
try
{
string sql = "select a.station_id,c.station_name_en,c.station_name_cn,c.station_name_tw from fimp.machine_info a, fimp.line_info b, fimp.station_info c where a.line_id=b.line_id and a.station_id = c.station_id and a.unit_no=b.unit_no and b.unit_no=c.unit_no and a.line_id={0}";
sql = string.Format(sql, line_id);
List <station_info> objList = new List <station_info>();
objList = PostgreHelper.GetEntityList <station_info>(sql);
return(objList);
}
catch (Exception ex)
{
throw ex;
}
}
//查询所有material_request_info
public List <material_request_info> SelectAll()
{
try
{
List <material_request_info> objList = new List <material_request_info>();
string sql = null;
sql = "SELECT * FROM fimp.material_request_info order by createtime";
sql = string.Format(sql);
objList = PostgreHelper.GetEntityList <material_request_info>(sql);
return(objList);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 加载记录
/// </summary>
/// <returns></returns>
public List <Attendance> GetAllAttendance()
{
try
{
List <Attendance> objList = new List <Attendance>();
string sql = null;
sql = "select * from fimp.attendance ";
objList = PostgreHelper.GetEntityList <Attendance>(sql);
return(objList);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 查询异常配置所关联的人员
/// </summary>
/// <param name="config_id">配置id</param>
/// <returns></returns>
public List <ErrorCfgPersonView> GetCfgPersonsView(int config_id)
{
List <ErrorCfgPersonView> list = new List <ErrorCfgPersonView>();
string command = string.Empty;
if (config_id > 0)
{
command = string.Format("SELECT * from andon.error_config_person_view where error_config_id='{0}' ", config_id);
}
if (command != string.Empty)
{
list = PostgreHelper.GetEntityList <ErrorCfgPersonView>(command);
}
return(list);
}
public List <MachineInfo> SelectByLine(int line_id)
{
try
{
List <MachineInfo> objList = new List <MachineInfo>();
string sql = null;
sql = "SELECT * FROM fimp.machine_info where line_id={0} ";
sql = string.Format(sql, line_id);
objList = PostgreHelper.GetEntityList <MachineInfo>(sql);
return(objList);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
///
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public List <Setting> SelectConfigList(int all_type)
{
try
{
List <Setting> objList = new List <Setting>();
string sql = null;
sql = "select id,config_list from jinchen.setting where all_type={0} order by config_list";
sql = string.Format(sql, all_type);
objList = PostgreHelper.GetEntityList <Setting>(sql);
return(objList);
}
catch (Exception ex)
{
throw ex;
}
}