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