/// <summary> /// 套餐 /// </summary> /// <returns></returns> public static List <Report> GetPInfoAll(LoginEx iiLoginEx, string tableName) { iLoginEx = iiLoginEx; List <Report> lst = new List <Report>(); try { OleDbConnection con = GetCon(); OpenCon(); string sql = "select * from " + tableName + ""; OleDbCommand com = new OleDbCommand(sql, con); com.CommandTimeout = 3600; OleDbDataReader dr = com.ExecuteReader(); while (dr.Read()) { Report r = FieldInfo(dr); lst.Add(r); } dr.Close(); CloseCon(); } catch (Exception ex) { MessageBox.Show("错误:" + ex.Message); } return(lst); }
/// <summary> /// 地区国内分组 /// </summary> /// <param name="iiLoginEx"></param> /// <returns></returns> public static List <Report> GroupByRCCCDistrict(LoginEx iiLoginEx, string district) { iLoginEx = iiLoginEx; List <Report> lst = new List <Report>(); try { OleDbConnection con = GetCon(); OpenCon(); string sql = "select * from zhrs_t_RegioncountryCitycustomer where District like '%" + district + "%'"; OleDbCommand com = new OleDbCommand(sql, con); com.CommandTimeout = 3600; OleDbDataReader dr = com.ExecuteReader(); while (dr.Read()) { Report r = FieldInfo(dr); lst.Add(r); } dr.Close(); CloseCon(); } catch (Exception ex) { MessageBox.Show("错误:" + ex.Message); } return(lst); }
/// <summary> /// 添加欠料表原采购回复 /// </summary> /// <param name="iLoginEx"></param> /// <param name="i"></param> /// <returns></returns> public static int AddMaterialShortage(LoginEx iiLoginEx, Infolst i) { iLoginEx = iiLoginEx; int n = 0; try { OleDbConnection con = GetCon(); OpenCon(); string sql = string.Format("insert into zhrs_t_zzcMaterialShortage(MCoding,MDate,MNumber,MExplain,MDescribe,MOther)values('{0}','{1}','{2}','{3}','{4}','{5}')", i.MCoding, i.Date, i.Num, i.Explain, i.Describe, i.MOther); OleDbCommand com = new OleDbCommand(sql, con); com.CommandTimeout = 3600; n = com.ExecuteNonQuery(); CloseCon(); } catch (Exception ex) { MessageBox.Show("错误: " + ex.Message); } finally { GC.Collect(); GC.Collect(1); } return(n); }
public frmMOM_Moallocate(UTLoginEx.LoginEx iiLoginEx, int iMoDid, string iMoCode, string icInvCode, string icInName, string icInStd, double iQty) { InitializeComponent(); iLoginEx = iiLoginEx; MoDid = iMoDid; MoCode = iMoCode; cInvCode = icInvCode; cInName = icInName; cInStd = icInStd; Qty = iQty; }
public StockQuery(LoginEx iiLoginEx, int iAuthID) { InitializeComponent(); iLoginEx = iiLoginEx; AuthID = iAuthID; }
public frmAPSQuery(UTLoginEx.LoginEx iiLoginEx) { InitializeComponent(); iLoginEx = iiLoginEx; }
public frmcInvCCodeTree(LoginEx iiLoginEx) { InitializeComponent(); iLoginEx = iiLoginEx; }