private void GetProductType() { FactoryTypeBLL ptb = new FactoryTypeBLL(); List <FactoryTypeModel> listfac = new List <FactoryTypeModel>(); ptb.GetFactoryTypeInfo(null, out listfac); foreach (FactoryTypeModel model in listfac) { ListItem item = new ListItem(); item.Value = model.FactoryTypeId.ToString(); item.Text = model.FactoryTypeName; typefac_ddl.Items.Add(item); } int id = Convert.ToInt32(Request.QueryString["id"]); ProductBLL pb = new ProductBLL(); List <ProductTypeModel> list = new List <ProductTypeModel>(); pb.GetProductSecondLevelInfo(null, out list); foreach (ProductTypeModel model in list) { if (model.S_ProductTypeId == id) { typeone_lb.Text = model.F_ProductTypeName; name_txt.Text = model.S_ProductTypeName; typefac_ddl.SelectedValue = model.FactoryTypeId.ToString(); break; } } }
protected void Page_Load(object sender, EventArgs e) { if (!Common.CheckPermission(Common.Module_Product_Type, Common.Permission_Add, HttpContext.Current)) { Response.Redirect("nopermission.aspx"); } else { ProductBLL pb = new ProductBLL(); List <ProductTypeModel> list = Common.GetProductTypeOneList(); foreach (ProductTypeModel model in list) { ListItem item = new ListItem(); item.Value = model.F_ProductTypeId.ToString(); item.Text = model.F_ProductTypeName; typeone_ddl.Items.Add(item); } FactoryTypeBLL ptb = new FactoryTypeBLL(); List <FactoryTypeModel> listfac = new List <FactoryTypeModel>(); ptb.GetFactoryTypeInfo(null, out listfac); foreach (FactoryTypeModel model in listfac) { ListItem item = new ListItem(); item.Value = model.FactoryTypeId.ToString(); item.Text = model.FactoryTypeName; typefac_ddl.Items.Add(item); } } }
protected void Page_Load(object sender, EventArgs e) { FactoryTypeBLL factorybll = new FactoryTypeBLL(); List <FactoryTypeModel> list = new List <FactoryTypeModel>(); factorybll.GetFactoryTypeInfoByNotUsed(out list); //Response.Write(list.Count.ToString()); string workTmp = Server.MapPath("~/Template/NewF_Template.xlsx"); string newfileTempFolder = Server.MapPath("~/Template/template_cache"); if (Directory.Exists(newfileTempFolder) == false) { Directory.CreateDirectory(newfileTempFolder); } string newfileTempFile = newfileTempFolder + "/" + DateTime.Now.Ticks.ToString() + ".xlsx"; File.Copy(workTmp, newfileTempFile); string strCon = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Extended Properties='Excel 12.0;HDR=YES;';" + "data source=" + newfileTempFile; ; using (OleDbConnection myConn = new OleDbConnection(strCon)) { myConn.Open(); string strCom = " insert into [厂家内部型号$] values ( @Name )"; foreach (FactoryTypeModel item in list) { OleDbCommand dbCommand = new OleDbCommand(strCom, myConn); dbCommand.Parameters.Add(new OleDbParameter("@Name", string.Format("{0}:{1}", item.FactoryTypeId, item.FactoryTypeName))); dbCommand.ExecuteNonQuery(); } } string filePath = newfileTempFile; FileInfo fileinfo = new FileInfo(filePath); Response.Clear(); //清除缓冲区流中的所有内容输出 Response.ClearContent(); //清除缓冲区流中的所有内容输出 Response.ClearHeaders(); //清除缓冲区流中的所有头 Response.Buffer = true; //该值指示是否缓冲输出,并在完成处理整个响应之后将其发送 Response.AddHeader("Content-Disposition", "attachment;filename=NewF_Template.xlsx"); Response.AddHeader("Content-Length", fileinfo.Length.ToString()); Response.AddHeader("Content-Transfer-Encoding", "binary"); Response.ContentType = "application/unknow"; //获取或设置输出流的 HTTP MIME 类型 Response.TransmitFile(filePath); Response.End(); Response.End(); }
private void GetFactoryType() { int id = Convert.ToInt32(Request.QueryString["id"]); FactoryTypeBLL ftb = new FactoryTypeBLL(); List <FactoryTypeModel> list = new List <FactoryTypeModel>(); ftb.GetFactoryTypeInfo(id, out list); if (list.Count > 0) { FactoryTypeModel model = (FactoryTypeModel)list[0]; name_txt.Text = model.FactoryTypeName; namep_txt.Text = model.ProductSecondLevelNameDefalut; } }
private void LoadTypeOne() { FactoryTypeBLL ftb = new FactoryTypeBLL(); List <FactoryTypeModel> olist = new List <FactoryTypeModel>(); ftb.GetFactoryTypeInfo(null, out olist); if (olist != null && olist.Count > 0) { typeone_ddl.DataValueField = "FactoryTypeId"; typeone_ddl.DataTextField = "FactoryTypeName"; typeone_ddl.DataSource = olist; typeone_ddl.DataBind(); } ListItem emptyitem = new ListItem(); emptyitem.Text = ""; emptyitem.Value = ""; typeone_ddl.Items.Insert(0, emptyitem); }
private void LoadTypeTwo(AdminModel user) { FactoryTypeBLL ftb = new FactoryTypeBLL(); List <FactoryTypeModel> olist = new List <FactoryTypeModel>(); ftb.GetFactoryTypeInfo(null, out olist); if (olist != null && olist.Count > 0) { typeone_ddl.DataValueField = "FactoryTypeId"; typeone_ddl.DataTextField = "FactoryTypeName"; typeone_ddl.DataSource = olist; typeone_ddl.DataBind(); } ListItem emptyitem = new ListItem(); emptyitem.Text = ""; emptyitem.Value = ""; typeone_ddl.Items.Insert(0, emptyitem); if (user.Type != AdminType.Managers) { Compensate_pl.Visible = false; } }