/// <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;
}