protected bool SaveToDB(string path, string tablename) { try { DataTable dt = ExcelManage.InputFromExcel(path, tablename); if (dt != null && dt.Rows.Count > 0) { WsSystem wbi = new WsSystem(); for (int i = 0; i < dt.Rows.Count; i++) { if (!string.IsNullOrEmpty(dt.Rows[i][0].ToString())) { BasBase bb = new BasBase(); bb.CODE = dt.Rows[i][0].ToString(); bb.NAME = dt.Rows[i][1].ToString(); bb.SubCode = dt.Rows[i][2].ToString(); bb.SubName = dt.Rows[i][3].ToString(); bb.MEMO = dt.Rows[i][4].ToString(); wbi.SaveBaseInfo(bb); } } return(true); } else { Label1.Text = "上传完毕,但数据为空,保存失败"; } return(true); } catch (Exception ex) { Label1.Text = ex.ToString(); return(false); } }
protected bool SaveToDB(string path, string tablename) { try { DataTable dt = ExcelManage.InputFromExcel(path, tablename); if (dt != null && dt.Rows.Count > 0) { WsSystem wbi = new WsSystem(); for (int i = 0; i < dt.Rows.Count; i++) { if (!string.IsNullOrEmpty(dt.Rows[i][0].ToString())) { FailItems bb = new FailItems(); bb.FailCode = dt.Rows[i][0].ToString(); bb.FailType = dt.Rows[i][1].ToString(); bb.FailMemo = dt.Rows[i][2].ToString(); bb.MEMO1 = dt.Rows[i][3].ToString(); wbi.SaveFailItems(bb); } } return(true); } else { Label1.Text = "上传完毕,但数据为空,保存失败"; } return(true); } catch (Exception ex) { Label1.Text = ex.ToString(); return(false); } }
/// <summary> /// 点击导出 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void ImgBtnExport_Click(object sender, ImageClickEventArgs e) { if (ActionValidator("SystemRolesExpert")) { DataTable dt = DbHelperSql.GetDataTable("SystemRoles", "RloeName,Remarks", (string.IsNullOrEmpty(tbRoleName.Text) ? string.Empty : " RoleName Like '%" + tbRoleName.Text + "%' "), "ID desc").Tables[0]; //导出; dt.Columns[0].ColumnName = "角色名称"; dt.Columns[1].ColumnName = "备注说明"; ExcelManage.HaikanExcelExport("角色信息列表", dt); } }
/// <summary> /// 点击导出 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void BtnExport_Click(object sender, EventArgs e) { DataTable dt = DbHelperSql.GetDataTable("SystemLog", "UserName,TimeStr,ActionStr,IPAddress", "UserName like '%" + txtUserName.Text.Trim() + "%' order by ID desc", "").Tables[0]; //导出; dt.Columns[0].ColumnName = "用户名"; dt.Columns[1].ColumnName = "日志时间"; dt.Columns[2].ColumnName = "操作内容"; dt.Columns[3].ColumnName = "IP地址"; ExcelManage.HaikanExcelExport("操作日志", dt); AddSystemLog("导出操作日志", "导出"); }
protected bool SaveToDB(string path, string tablename) { try { DataTable dt = ExcelManage.InputFromExcel(path, tablename); if (dt != null && dt.Rows.Count > 0) { WsSystem wbi = new WsSystem(); for (int i = 0; i < dt.Rows.Count; i++) { if (!string.IsNullOrEmpty(dt.Rows[i][0].ToString())) { WorkOrderDetails bb = new WorkOrderDetails(); bb.WO = wbi.GetWorkOrderCode();// PubHelper.GetHelper().GetNextID("MES_MASTER.SEQ_ALL_ID").ToString(); bb.OrderNumber = dt.Rows[i][0].ToString(); bb.PartsdrawingCode = dt.Rows[i][1].ToString(); bb.MachineType = dt.Rows[i][2].ToString(); bb.MachineName = dt.Rows[i][3].ToString(); bb.ProductName = dt.Rows[i][4].ToString(); bb.StartTime = Convert.ToDateTime(dt.Rows[i][5].ToString()); bb.EndTime = Convert.ToDateTime(dt.Rows[i][6].ToString()); bb.BatchNumber = dt.Rows[i][7].ToString(); bb.PlanQuantity = Convert.ToDecimal(dt.Rows[i][8].ToString()); bb.CheckTime = Convert.ToDateTime(dt.Rows[i][9].ToString()); bb.InstockTime = Convert.ToDateTime(dt.Rows[i][10].ToString()); string res = wbi.SaveWorkOrderInfo(bb); if (res != "OK") { Label1.Text = res; return(false); } } } return(true); } else { Label1.Text = "上传完毕,但数据为空,保存失败"; } return(true); } catch (Exception ex) { Label1.Text = ex.ToString(); return(false); } }
protected bool SaveToDB(string path, string tablename) { try { DataTable dt = ExcelManage.InputFromExcel(path, tablename); if (dt != null && dt.Rows.Count > 0) { WsSystem wbi = new WsSystem(); string orderno = wbi.GetOrderNoCode(); for (int i = 0; i < dt.Rows.Count; i++) { if (!string.IsNullOrEmpty(dt.Rows[i][0].ToString())) { OrderDetail bb = new OrderDetail(); bb.OrderNo = orderno;// dt.Rows[i][0].ToString(); bb.CustName = dt.Rows[i][0].ToString(); bb.CONTRACT = dt.Rows[i][1].ToString(); bb.ProductName = dt.Rows[i][2].ToString(); bb.PartsdrawingCode = dt.Rows[i][3].ToString(); bb.BatchNumber = dt.Rows[i][4].ToString(); bb.OrderQuantity = Convert.ToDecimal(dt.Rows[i][5].ToString()); bb.OutDate = Convert.ToDateTime(dt.Rows[i][6].ToString()); bb.CheckTime = Convert.ToDateTime(dt.Rows[i][7].ToString()); string res = wbi.SaveOrderInfo(bb); if (res != "OK") { Label1.Text = res; return(false); } } } return(true); } else { Label1.Text = "上传完毕,但数据为空,保存失败"; } return(true); } catch (Exception ex) { Label1.Text = ex.ToString(); return(false); } }
protected bool SaveToDB(string path, string tablename) { try { DataTable dt = ExcelManage.InputFromExcel(path, tablename); if (dt != null && dt.Rows.Count > 0) { WsBasic wbi = new WsBasic(); for (int i = 0; i < dt.Rows.Count; i++) { if (!string.IsNullOrEmpty(dt.Rows[i][0].ToString())) { BasCustom bc = new BasCustom(); bc.CODE = dt.Rows[i][0].ToString(); bc.NAME = dt.Rows[i][1].ToString(); bc.ADDRESS = dt.Rows[i][2].ToString(); bc.TransType = dt.Rows[i][3].ToString(); bc.ReceiveArea = dt.Rows[i][4].ToString(); bc.CONTACT = dt.Rows[i][5].ToString(); bc.MOBILE = dt.Rows[i][6].ToString(); bc.FAX = dt.Rows[i][7].ToString(); bc.InvoiceName = dt.Rows[i][8].ToString(); bc.InvoiceNumber = dt.Rows[i][9].ToString(); string result = wbi.SaveCust(bc); if (!string.IsNullOrEmpty(result) && result != "OK") { Label1.Text = result; return(false); } } } return(true); } else { Label1.Text = "上传完毕,但数据为空,保存失败!"; } return(true); } catch (Exception ex) { Label1.Text = ex.ToString(); return(false); } }
protected bool SaveToDB(string path, string tablename) { try { DataTable dt = ExcelManage.InputFromExcel(path, tablename); if (dt != null && dt.Rows.Count > 0) { WsSystem wbi = new WsSystem(); for (int i = 0; i < dt.Rows.Count; i++) { if (!string.IsNullOrEmpty(dt.Rows[i][0].ToString())) { PartsdrawingCode bb = new PartsdrawingCode(); bb.ID = PubHelper.GetHelper().GetNextID("MES_MASTER.SEQ_ALL_ID").ToString(); bb.PartsCode = dt.Rows[i][0].ToString(); bb.CustName = dt.Rows[i][1].ToString(); bb.CustCode = dt.Rows[i][2].ToString(); bb.ProductName = dt.Rows[i][3].ToString(); bb.ProductCode = dt.Rows[i][4].ToString(); bb.PlanQuantity = Convert.ToDecimal(dt.Rows[i][5].ToString()); bb.QualityCode = dt.Rows[i][6].ToString(); bb.AskQuantity = Convert.ToDecimal(dt.Rows[i][7].ToString()); bb.BatchNumber = dt.Rows[i][8].ToString(); bb.AskDate = Convert.ToDateTime(dt.Rows[i][9].ToString()); bb.ACTIVE = "1"; wbi.SavePartsDrawing(bb); } } return(true); } else { Label1.Text = "上传完毕,但数据为空,保存失败"; } return(true); } catch (Exception ex) { Label1.Text = ex.ToString(); return(false); } }
protected bool SaveToDB(string path, string tablename) { try { DataTable dt = ExcelManage.InputFromExcel(path, tablename); if (dt != null && dt.Rows.Count > 0) { WsSystem wbi = new WsSystem(); for (int i = 0; i < dt.Rows.Count; i++) { if (!string.IsNullOrEmpty(dt.Rows[i][0].ToString())) { BasEquipment bb = new BasEquipment(); bb.CODE = dt.Rows[i][0].ToString(); bb.COMPANY = dt.Rows[i][1].ToString(); bb.MachineName = dt.Rows[i][2].ToString(); bb.MachineType = dt.Rows[i][3].ToString(); bb.AxisNumber = dt.Rows[i][4].ToString(); bb.MODEL = dt.Rows[i][5].ToString(); bb.POWER = dt.Rows[i][6].ToString(); bb.LOCATION = dt.Rows[i][7].ToString(); bb.STATUS = dt.Rows[i][8].ToString(); bb.OutCode = dt.Rows[i][9].ToString(); bb.UseDate = Convert.ToDateTime(string.IsNullOrEmpty(dt.Rows[i][10].ToString())?DateTime.Now.ToShortDateString(): dt.Rows[i][10].ToString()); wbi.SaveEquipmentInfo(bb); } } return(true); } else { Label1.Text = "上传完毕,但数据为空,保存失败"; } return(true); } catch (Exception ex) { Label1.Text = ex.ToString(); return(false); } }
protected bool SaveToDB(string path, string tablename) { try { DataTable dt = ExcelManage.InputFromExcel(path, tablename); if (dt != null && dt.Rows.Count > 0) { WsSystem wbi = new WsSystem(); for (int i = 0; i < dt.Rows.Count; i++) { if (!string.IsNullOrEmpty(dt.Rows[i][0].ToString())) { WorkOrderDetails bb = new WorkOrderDetails(); bb.WO = dt.Rows[i][0].ToString();// PubHelper.GetHelper().GetNextID("MES_MASTER.SEQ_ALL_ID").ToString(); bb.WorkerName = dt.Rows[i][1].ToString(); bb.WORKER = wbi.FindUserCodeByUserName(bb.WorkerName); bb.StationName = dt.Rows[i][2].ToString(); bb.RouteCode = dt.Rows[i][3].ToString(); string res = wbi.SaveWorkOrderAssign(bb); if (res != "OK") { Label1.Text = res; return(false); } } } return(true); } else { Label1.Text = "上传完毕,但数据为空,保存失败"; } return(true); } catch (Exception ex) { Label1.Text = ex.ToString(); return(false); } }
protected bool SaveToDB(string path, string tablename) { try { DataTable dt = ExcelManage.InputFromExcel(path, tablename); if (dt != null && dt.Rows.Count > 0) { WsSystem wbi = new WsSystem(); for (int i = 0; i < dt.Rows.Count; i++) { if (!string.IsNullOrEmpty(dt.Rows[i][0].ToString())) { TechnologyWip bb = new TechnologyWip(); bb.PARTSDRAWINGNO = dt.Rows[i][0].ToString();// PubHelper.GetHelper().GetNextID("MES_MASTER.SEQ_ALL_ID").ToString(); bb.CustName = dt.Rows[i][1].ToString(); bb.ProductName = dt.Rows[i][2].ToString(); bb.ProcessName = dt.Rows[i][3].ToString(); bb.ProcessEngineer = wbi.FindUserCodeByUserName(bb.ProcessName); bb.PlanDate = Convert.ToDateTime(dt.Rows[i][4].ToString()); bb.STATUS = 1; bb.StatusMemo = "分派工艺"; wbi.SaveTechnologyInfoForImport(bb); } } return(true); } else { Label1.Text = "上传完毕,但数据为空,保存失败"; } return(true); } catch (Exception ex) { Label1.Text = ex.ToString(); return(false); } }
public ActionResult ExportWorkShopReport() { try { DataTable dt = ToDataTable(list); string path = Server.MapPath("~/Files"); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } string tempFile = Guid.NewGuid() + ".xlsx"; string filePath = Path.Combine(path, tempFile); ExcelManage.TableToExcel(dt, filePath); return(Json(new { ExcelUrl = filePath, Name = "VSS_WorkShopReport_" + System.DateTime.Now.ToString("yyyy-MM-dd") + ".xlsx", stat = true }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { Name = "VSS_WorkShopReport_" + System.DateTime.Now.ToString("yyyy-MM-dd") + ".xlsx", stat = false }, JsonRequestBehavior.AllowGet)); } }
protected bool SaveToDB(string path, string tablename) { try { DataTable dt = ExcelManage.InputFromExcel(path, tablename); if (dt != null && dt.Rows.Count > 0) { WsSystem wbi = new WsSystem(); for (int i = 0; i < dt.Rows.Count; i++) { if (!string.IsNullOrEmpty(dt.Rows[i][0].ToString())) { BasMateriel bb = new BasMateriel(); bb.QPARTNO = dt.Rows[i][0].ToString(); bb.CPARTNO = dt.Rows[i][1].ToString(); bb.NAME = dt.Rows[i][2].ToString(); bb.BasQty = Convert.ToInt32(dt.Rows[i][3].ToString()); bb.CUSTOMER = dt.Rows[i][4].ToString(); bb.MEMO = dt.Rows[i][5].ToString(); wbi.SaveMaterielInfo(bb); } } return(true); } else { Label1.Text = "上传完毕,但数据为空,保存失败"; } return(true); } catch (Exception ex) { Label1.Text = ex.ToString(); return(false); } }