public static string getWeekData()
{
string res = string.Empty;
DateTime dt = DateTime.Now;
DateTime sw = dt.AddDays(1 - Convert.ToInt32(dt.DayOfWeek.ToString("d")));
/// 获取本周各班组的产量信息
string sql_w = "select ShiftGroup SHIFT,sum(Quantity) Quantity from [Plex_Daily_Production] where " +
"report_date between '" + sw.Date.ToString() + "' and '" + dt.Date.ToString() + "' group by ShiftGroup";
DataSet dsw = new DataSet();
dsw = FGA_DAL.Base.SQLServerHelper_WMS.Query(sql_w);
if (dsw != null && dsw.Tables.Count > 0 && dsw.Tables[0].Rows.Count > 0)
{
List <userctrlModel> luw = new List <userctrlModel>();
foreach (DataRow row in dsw.Tables[0].Rows)
{
userctrlModel ERM = new userctrlModel(row);
luw.Add(ERM);
}
//获取workcenter对应的产量
JavaScriptSerializer jssl = new JavaScriptSerializer();
res = jssl.Serialize(luw);
}
return(res);
}
public static string InitPage(string data)
{
string res = string.Empty;
try
{
//获取序列号
string SEQ = "";
string SEQ_sql = "select next value for honda_sequence_seq as HS ";
DataSet ds_seq = new DataSet();
ds_seq = FGA_DAL.Base.SQLServerHelper_FGA.Query(SEQ_sql);
if (ds_seq != null && ds_seq.Tables.Count > 0 && ds_seq.Tables[0].Rows.Count > 0)
{
SEQ = "PHO" + ds_seq.Tables[0].Rows[0][0].ToString();
}
UsersModel model = (UsersModel)HttpContext.Current.Session[SysConst.S_LOGIN_USER];
string sql = "SELECT DISTINCT UC.[ORGANIZATION],UC.[USERNAME],UC.[OPERATION],FPT.[TLOC] AS [WorkCenter]" +
" FROM [FGA_PLATFORM].[dbo].[UserCtrl] UC LEFT JOIN [FGA_PARTTRANSFER_T] FPT ON UC.OPERATION = FPT.OPERATION where UC.USERNAME = '******' AND UC.TRANSACTIONTYPE = '{1}' and UC.UTYPE = '01'";
sql = string.Format(sql, model.USERNAME, data);
DataSet ds = new DataSet();
ds = FGA_DAL.Base.SQLServerHelper.Query(sql);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
List <HandOverHead> luw = new List <HandOverHead>();
HandOverHead HOH = new HandOverHead();
foreach (DataRow row in ds.Tables[0].Rows)
{
userctrlModel UM = new userctrlModel(row);
HOH.ORGANIZATION = UM.ORGANIZATION;
HOH.OPERATION = UM.OPERATION;
HOH.BATCHNO = SEQ;
HOH.WORKCENTER = UM.WORKCENTER;
luw.Add(HOH);
}
JavaScriptSerializer jssl = new JavaScriptSerializer();
res = jssl.Serialize(luw);
}
}
catch (Exception e)
{
}
return(res);
}
public static string getWorkCenter()
{
//按用户查看数据
UsersModel model = (UsersModel)HttpContext.Current.Session[SysConst.S_LOGIN_USER];
string sql = "";
string res = string.Empty;
try
{
sql = "SELECT [WorkCenter] FROM [UserWorkCenter_t] where UserName = '******' and Ptype = 'output'";
DataSet ds = new DataSet();
ds = FGA_DAL.Base.SQLServerHelper_WMS.Query(sql);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
List <userctrlModel> luw = new List <userctrlModel>();
foreach (DataRow row in ds.Tables[0].Rows)
{
userctrlModel ERM = new userctrlModel(row);
luw.Add(ERM);
}
//同步workcenter当班的产量
List <userctrlModel> nwt = getOutPut(luw);
//获取workcenter对应的产量
JavaScriptSerializer jssl = new JavaScriptSerializer();
res = jssl.Serialize(nwt);
}
}
catch (Exception e)
{
}
return(res);
}
