void QueryList()
{
string page = Request.Params["page"];
string pagesize = Request.Params["rows"];
if (string.IsNullOrEmpty(page))
{
page = "1";
}
if (string.IsNullOrEmpty(pagesize))
{
pagesize = "15";
}
mg_insertco_customerordertable cot = new mg_insertco_customerordertable();
string sql = @"
SELECT co.OrderID,
isnull (co.CustomerNumber, '') AS CustomerNumber,
isnull (co.JITCallNumber, '') AS JITCallNumber,
isnull (co.SerialNumber, '') AS SerialNumber,
isnull (co.VinNumber, '') AS VinNumber,
isnull (co.PlanDeliverTime, '') AS PlanDeliverTime,
isnull (prod.ProductNo, '') AS ProductNo,
isnull (prod.ProductName, '') AS ProductName
FROM mg_CustomerOrder_3 co
INNER JOIN mg_Customer_Product coprod
ON co.OrderID = coprod.CustomerOrderID
INNER JOIN mg_Product prod ON coprod.ProductID = prod.ID
WHERE co.OrderType = 3 and datediff(day,co.CreateTime,getdate())<15 and prod.IsUseing=1
ORDER BY co.CreateTime DESC";
DataTable dt;
dt = SqlHelper.GetDataDataTable(SqlHelper.SqlConnString, CommandType.Text, sql, null);
int iPage = Convert.ToInt32(page);
int iPageZize = Convert.ToInt32(pagesize);
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
if (i < (iPage - 1) * iPageZize || i >= (iPage * iPageZize))
{
continue;
}
mg_insertco_customerorder itm = new mg_insertco_customerorder();
itm.OrderID = Convert.ToInt32(dr["OrderID"]);
itm.CustomerNumber = dr["CustomerNumber"].ToString();
itm.JITCallNumber = dr["JITCallNumber"].ToString();
itm.SerialNumber = dr["SerialNumber"].ToString();
itm.VinNumber = dr["VinNumber"].ToString();
itm.PlanDeliverTime = dr["PlanDeliverTime"].ToString();
itm.ProductNo = dr["ProductNo"].ToString();
itm.ProductName = dr["ProductName"].ToString();
cot.rows.Add(itm);
}
cot.total = dt.Rows.Count.ToString();
string jsonStr = JSONTools.ScriptSerialize <mg_insertco_customerordertable>(cot);
Response.Write(jsonStr);
Response.End();
}
void QueryPart(string strProductList)
{
mg_insertco_parttable pt = new mg_insertco_parttable();
DataTable dt;
string sql = @"
SELECT part_id, part_no, part_name, part_desc FROM mg_part
WHERE charindex (',' + CONVERT (NVARCHAR (20), productID) + ',', '," + strProductList + @",') > 0";
dt = SqlHelper.GetDataDataTable(SqlHelper.SqlConnString, CommandType.Text, sql, null);
foreach (DataRow dr in dt.Rows)
{
mg_insertco_part itm = new mg_insertco_part();
itm.part_id = Convert.ToInt32(dr["part_id"]);
itm.part_no = dr["part_no"].ToString();
itm.part_name = dr["part_name"].ToString();
itm.part_desc = dr["part_desc"].ToString();
pt.rows.Add(itm);
}
pt.total = dt.Rows.Count.ToString();
string jsonStr = JSONTools.ScriptSerialize <mg_insertco_parttable>(pt);
Response.Write(jsonStr);
Response.End();
}
public static string QueryPartForPartidList()
{
List <mg_partModel> list = mg_PartDAL.QueryPartForPartidList();
string jsonStr = JSONTools.ScriptSerialize <List <mg_partModel> >(list);
return(jsonStr);
}
/// <summary>
/// 查询全部宣传口号
/// </summary>
/// <returns></returns>
public static string QueryAndonTaglinesList()
{
List <Andon_Taglines> tempList = AndonTaglinesDAL.QueryAndonTaglinesList();
String jsonStr = JSONTools.ScriptSerialize <List <Andon_Taglines> >(tempList);
return(jsonStr);
}
public string GetListNew(HttpContext context)
{
string start_time = context.Request["start_time"];
string end_time = context.Request["end_time"];
int PageSize = Convert.ToInt32(context.Request["rows"]);
int PageIndex = Convert.ToInt32(context.Request["page"]);
StringBuilder commandText = new StringBuilder();
string where = "";
if (string.IsNullOrEmpty(start_time))
{
DateTime t = DateTime.Now.AddMonths(-1);
start_time = t.ToString("yyyy-MM-dd");
}
string StartTime = start_time.Substring(0, 10);
if (string.IsNullOrEmpty(end_time))
{
DateTime t = DateTime.Now;
end_time = t.ToString("yyyy-MM-dd");
}
string EndTime = end_time.Substring(0, 10);
int StartIndex = (PageIndex - 1) * PageSize + 1;
int EndIndex = PageIndex * PageSize;
DataListModel <Production_AlarmModel> userList = Production_AlarmTrendReport_BLL.GetListNew(StartTime, EndTime, StartIndex, EndIndex);
string json = JSONTools.ScriptSerialize <DataListModel <Production_AlarmModel> >(userList);
return(json);
}
public static string getList(int PageSize, int StartIndex, int EndIndex, string SortFlag, string sortOrder, string wherestr)
{
if (string.IsNullOrEmpty(SortFlag))
{
SortFlag = " st_no,step_startTime";
}
if (string.IsNullOrEmpty(sortOrder))
{
sortOrder = "asc";
}
List <mg_sys_log> list = new List <mg_sys_log>();
int total = 0;
string query_sql = " select * from(select row_number() over(order by " + SortFlag + " " + sortOrder + " ) as rowid,report.* from View_mg_sys_log report where 1 = 1 " + wherestr + ") as Results where rowid >=" + StartIndex + " and rowid <=" + EndIndex + " ";
string count_sql = "select count(*) as total from View_mg_sys_log where 1 = 1 " + wherestr;
DataSet ds = SqlHelper.GetDataSetTableMapping(SqlHelper.SqlConnString, System.Data.CommandType.Text, count_sql + query_sql, new string[] { "count", "data" }, null);
if (DataHelper.HasData(ds))
{
DataTable dt1 = ds.Tables["count"];
total = NumericParse.StringToInt(DataHelper.GetCellDataToStr(dt1.Rows[0], "total"));
DataTable dt2 = ds.Tables["data"];
foreach (DataRow row in dt2.Rows)
{
mg_sys_log model = new mg_sys_log();
model.sys_id = DataHelper.GetCellDataToStr(row, "sys_id");
model.op_id = DataHelper.GetCellDataToStr(row, "op_id");
model.op_name = DataHelper.GetCellDataToStr(row, "op_name");
model.fl_id = DataHelper.GetCellDataToStr(row, "fl_id");
model.fl_name = DataHelper.GetCellDataToStr(row, "fl_name");
model.st_id = DataHelper.GetCellDataToStr(row, "st_id");
model.st_no = DataHelper.GetCellDataToStr(row, "st_no");
model.PartOrderID = DataHelper.GetCellDataToStr(row, "PartOrderID");
model.or_no = DataHelper.GetCellDataToStr(row, "or_no");
model.part_no = DataHelper.GetCellDataToStr(row, "part_no");
model.step_order = NumericParse.StringToInt(DataHelper.GetCellDataToStr(row, "step_order"));
model.step_startTime = DataHelper.GetCellDataToStr(row, "step_startTime");
model.step_endTime = DataHelper.GetCellDataToStr(row, "step_endTime");
model.step_duringtime = DataHelper.GetCellDataToStr(row, "step_duringtime");
model.AngleResult = DataHelper.GetCellDataToStr(row, "AngleResult");
model.TorqueResult = DataHelper.GetCellDataToStr(row, "TorqueResult");
model.scanCode = DataHelper.GetCellDataToStr(row, "scanCode");
model.scanResult = DataHelper.GetCellDataToStr(row, "scanResult");
model.sys_desc = DataHelper.GetCellDataToStr(row, "sys_desc");
model.ScrewCount = DataHelper.GetCellDataToStr(row, "ScrewCount");
model.MenderName = DataHelper.GetCellDataToStr(row, "MenderName");
model.ReviseTime = DataHelper.GetCellDataToStr(row, "ReviseTime");
list.Add(model);
}
}
DataListModel <mg_sys_log> allmodel = new DataListModel <mg_sys_log>();
allmodel.total = total.ToString();
allmodel.rows = list;
string jsonStr = JSONTools.ScriptSerialize <DataListModel <mg_sys_log> >(allmodel);
return(jsonStr);
}
public static string QueryBOMForStepEditing(string part_id)
{
string jsonStr = "[]";
List <mg_BOMModel> list = mg_BomDAL.QueryBOMForStepEditing(part_id);
jsonStr = JSONTools.ScriptSerialize <List <mg_BOMModel> >(list);
return(jsonStr);
}
public static string queryGroupidForBOMTest()
{
string jsonStr = "[]";
List <mg_BOMTestGroupModel> list = mg_BOMTestGroupDAL.queryGroupidForBOMTest();
jsonStr = JSONTools.ScriptSerialize <List <mg_BOMTestGroupModel> >(list);
return(jsonStr);
}
public static string QueryDepartmentsForUser()
{
string jsonStr = "[]";
List <mg_DepartmentModel> list = mg_DepartmentDAL.QueryDepartmentsForUser();
jsonStr = JSONTools.ScriptSerialize <List <mg_DepartmentModel> >(list);
return(jsonStr);
}
public static string queryProductidForPart()
{
string jsonStr = "[]";
List <mg_ProductModel> list = mg_ProductDAL.queryProductidForPart();
jsonStr = JSONTools.ScriptSerialize <List <mg_ProductModel> >(list);
return(jsonStr);
}
public static string queryJSONStringByPropertyType(mg_PropertyEnum propEnum)
{
string jsonStr = "[]";
List <mg_PropertyModel> list = mg_PropertyDAL.queryJSONStringByPropertyType(propEnum);
jsonStr = JSONTools.ScriptSerialize <List <mg_PropertyModel> >(list);
return(jsonStr);
}
public static string queryProductForEditing(string type)
{
string jsonStr = "[]";
List <mg_PropertyModel> list = mg_PropertyDAL.QueryPropertyFlowlingForEditing(type);
jsonStr = JSONTools.ScriptSerialize <List <mg_PropertyModel> >(list);
return(jsonStr);
}
/// <summary>
/// 获取菜单树
/// </summary>
/// <returns></returns>
public static string GetMenuTree()
{
string jsonStr = "[]";
List <MenuTree> menuList = Sys_MenuDAL.GetMenuTree();
jsonStr = JSONTools.ScriptSerialize <List <MenuTree> >(menuList);
return(jsonStr);
}
/// <summary>
/// 获取用户菜单列表
/// </summary>
/// <param name="menutitle"></param>
/// <returns></returns>
public static string GetMenuList(string menutitle, string currentuser)
{
string jsonStr = "[]";
List <Sys_Menu> menuList = Sys_MenuDAL.GetUserMenuList(menutitle, currentuser);
jsonStr = JSONTools.ScriptSerialize <List <Sys_Menu> >(menuList);
return(jsonStr);
}
public static string QueryFlowlingForStepEditing()
{
string jsonStr = "[]";
List <mg_FlowlingModel> list = mg_FlowLineDAL.QueryFlowlingForStepEditing();
jsonStr = JSONTools.ScriptSerialize <List <mg_FlowlingModel> >(list);
return(jsonStr);
}
public static string QueryODSByStepid(string step_id)
{
string jsonStr = "[]";
List <mg_ODSModel> list = mg_StepDAL.QueryODSByStepid(step_id);
jsonStr = JSONTools.ScriptSerialize <List <mg_ODSModel> >(list);
return(jsonStr);
}
public static string QueryTestList()
{
string jsonStr = "[]";
List <mg_TestModel> list = mg_TestDAL.QueryTestList();
jsonStr = JSONTools.ScriptSerialize <List <mg_TestModel> >(list);
return(jsonStr);
}
public static string QueryInternetPrinterListForPart()
{
string jsonStr = "[]";
List <px_InternetPrinterModel> list = px_InternetPrinterDAL.QueryInternetPrinterListForPart();
jsonStr = JSONTools.ScriptSerialize <List <px_InternetPrinterModel> >(list);
return(jsonStr);
}
public static string QueryPositionsForUser()
{
string jsonStr = "[]";
List <mg_PositionModel> list = mg_PositionDAL.QueryPositionsForUser();
jsonStr = JSONTools.ScriptSerialize <List <mg_PositionModel> >(list);
return(jsonStr);
}
public static string QueryMaterialSortingListForPart()
{
string jsonStr = "[]";
List <px_ShowChiClientModel> list = px_ShowChiClientDAL.Querypx_ShowChiClientListForPart();
jsonStr = JSONTools.ScriptSerialize <List <px_ShowChiClientModel> >(list);
return(jsonStr);
}
public static string queryFlowLineidForPart()
{
string jsonStr = "[]";
List <mg_FlowlingModel> list = mg_FlowLine1DAL.queryFlowLineidForPart();
jsonStr = JSONTools.ScriptSerialize <List <mg_FlowlingModel> >(list);
return(jsonStr);
}
public static string querySupplierForBOM(string type)
{
string jsonStr = "[]";
List <Mat_SupplierListModel> list = mg_MaterialPropertyDAL.querySupplierForBOM(type);
jsonStr = JSONTools.ScriptSerialize <List <Mat_SupplierListModel> >(list);
return(jsonStr);
}
public static string QueryAllPartListForPart()
{
string jsonStr = "[]";
List <mg_allpartModel> list = mg_allpartDAL.QueryAllPartListForPart();
jsonStr = JSONTools.ScriptSerialize <List <mg_allpartModel> >(list);
return(jsonStr);
}
public static string QueryMaterialPropertyTypeForEditing()
{
string jsonStr = "[]";
List <Mg_MaterialPropertyTypeModel> list = mg_MaterialPropertyDAL.QueryMaterialPropertyTypeForEditing();
jsonStr = JSONTools.ScriptSerialize <List <Mg_MaterialPropertyTypeModel> >(list);
return(jsonStr);
}
static string queryJSONStringByPropertyType(string type)
{
string jsonStr = "[]";
List <mg_MaterialPropertyModel> list = mg_MaterialPropertyDAL.queryJSONStringByPropertyType(type);
jsonStr = JSONTools.ScriptSerialize <List <mg_MaterialPropertyModel> >(list);
return(jsonStr);
}
public static string QueryStationStnoList()
{
string jsonStr = "[]";
List <mg_stationModel> list = mg_StationDAL.QueryStationStnoList();
jsonStr = JSONTools.ScriptSerialize <List <mg_stationModel> >(list);
return(jsonStr);
}
public static string QueryStationForStepEditing(string fl_id)
{
string jsonStr = "[]";
List <mg_stationModel> list = mg_StationDAL.QueryStationForStepEditing(fl_id);
jsonStr = JSONTools.ScriptSerialize <List <mg_stationModel> >(list);
return(jsonStr);
}
public static string queryPartForStepSearching()
{
string jsonStr = "[]";
List <mg_partModel> list = mg_PartDAL.queryPartForStepSearching();
jsonStr = JSONTools.ScriptSerialize <List <mg_partModel> >(list);
return(jsonStr);
}
public static string QueryPoInspectItemListALL()
{
string jsonStr = "[]";
List <mg_PoInspectItemModel> list = null;
string total = "0";
list = QueryListALL(out total);
mg_PoInspectItemPageModel model = new mg_PoInspectItemPageModel();
model.total = total;
model.rows = list;
jsonStr = JSONTools.ScriptSerialize <mg_PoInspectItemPageModel>(model);
return(jsonStr);
}
public static string QueryUserList(string page, string pagesize)
{
string jsonStr = "[]";
List <mg_userModel> list = null;
string total = "0";
list = QueryListForFirstPage(page, pagesize, out total);
mg_userDataModel model = new mg_userDataModel();
model.total = total;
model.rows = list;
jsonStr = JSONTools.ScriptSerialize <mg_userDataModel>(model);
return(jsonStr);
}