protected void BtnSave_Click(object sender, System.Web.UI.ImageClickEventArgs e) { if (assetclassify.Value.Trim().Length == 0) { baseOperation.ShowErrorMessage(this.Page, "资产分类不能为空!"); } bool IsIn = this.NameIsIn(dropAdmindept.SelectedValue.Trim(), assetclassify.Value.Trim()); bool codeIsIn = this.CodeIsIn(maxcode.Value.Trim()); if (fixedbarcode.Value.Trim().Length == 0) { baseOperation.ShowErrorMessage(this.Page, "固定条码不能为空!"); } else if (fixedbarcode.Value.Trim().Length < 3) { baseOperation.ShowErrorMessage(this.Page, "固定条码长度不能小于3位!"); } //else if (IsIn == true) //{ // baseOperation.ShowErrorMessage(this.Page, "已经存在该管理部门和资产分类的条码设置!"); //} //else if (codeIsIn == true) //{ // baseOperation.ShowErrorMessage(this.Page, "已经存在该固定条码的设置!"); //} else { BARCODESETTINGModel model = new BARCODESETTINGModel(); model.BARCODEID = Int32.Parse(hdBarcodeId.Value.Trim()); model.DEPTCODE = dropAdmindept.SelectedValue; model.ASSETCLASSIFY = assetclassify.Value.Trim(); model.FIXEDBARCODE = fixedbarcode.Value.Trim(); model.MAXCODE = Int32.Parse(maxcode.Value.Trim()); model.COMMENTS = comments.Value.Trim(); model.PlantID = ddPlant.SelectedValue; model.EmployeeID = txtEmployee.Text; dal.Update(model); string url; url = "Success.aspx?backUrl=AddBarcodeByEmployeeID.aspx&erorMessage=条形码信息修改成功!"; Log.WriteLog("", Session["username"] + ":条形码信息修改成功"); Response.Redirect(url); } }
protected void BtnUpload_Click(object sender, System.Web.UI.ImageClickEventArgs e) { string filepath = Server.MapPath("./"); //当前路径 string fileName = FileUpload1.FileName; if (fileName.Length > 0) { filepath += fileName; FileUpload1.SaveAs(filepath); try { string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + filepath + ";" + "Extended Properties=\"Excel 8.0;\""; OleDbConnection conn = new OleDbConnection(strConn); conn.Open(); string strExcel = ""; OleDbDataAdapter myCommand = null; DataSet ds = null; strExcel = "select * from [sheet1$]"; myCommand = new OleDbDataAdapter(strExcel, strConn); ds = new DataSet(); myCommand.Fill(ds, "table1"); conn.Close(); conn.Dispose(); int count = 0; //不存在的资产编码 string noexitCode = ""; //已经导入条码的资产编码 string existCode = ""; //不存在的资产分类 string noexistClassify = ""; //条形码长度不等于9 string lengtherror = ""; if (ds != null && ds.Tables[0].Rows.Count > 0) { FIXEDASSETINFODal assetDal = new FIXEDASSETINFODal(); FIXEDASSETINFOModel assetModel = new FIXEDASSETINFOModel(); BARCODESETTINGDal setDal = new BARCODESETTINGDal(); BARCODESETTINGModel setModel = new BARCODESETTINGModel(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DataRow dr = ds.Tables[0].Rows[i]; assetModel = assetDal.GetModel(dr[0].ToString().Trim()); if (assetModel != null) { string barcode = dr[1].ToString().Trim(); if (barcode.Length == 9) { setModel = setDal.GetModelDueCode(barcode.Substring(0, 3)); if (setModel != null) { if (assetModel.BARCODE != null && assetModel.BARCODE.Length > 0 && assetModel.ADMINDEPT != null && assetModel.ADMINDEPT.Length > 0 && (!assetModel.ADMINDEPT.Equals(setModel.DEPTCODE))) { if (existCode.Length > 0) { existCode = existCode + "," + dr[0].ToString().Trim(); } else { existCode = dr[0].ToString().Trim(); } } else { assetModel.BARCODE = barcode; if (setModel != null) { assetModel.ADMINDEPT = setModel.DEPTCODE; assetModel.ASSETCLASSIFY = setModel.ASSETCLASSIFY; } assetDal.Update(assetModel); int maxcode = int.Parse(barcode.Substring(3)); if (setModel.MAXCODE < maxcode) { setModel.MAXCODE = maxcode; setDal.Update(setModel); } count++; } } else { if (noexistClassify.Length > 0) { noexistClassify = noexistClassify + "," + dr[0].ToString().Trim(); } else { noexistClassify = dr[0].ToString().Trim(); } } } else { if (lengtherror.Length > 0) { lengtherror = lengtherror + "," + dr[0].ToString().Trim(); } else { lengtherror = dr[0].ToString().Trim(); } } } else { if (noexitCode.Length > 0) { noexitCode = noexitCode + "," + dr[0].ToString().Trim(); } else { noexitCode = dr[0].ToString().Trim(); } } } string strMsg = ""; if (noexitCode.Length > 0) { strMsg = strMsg + @"系统中不存在资产编码[" + noexitCode + "]。"; } if (lengtherror.Length > 0) { if (strMsg.Length > 0) { strMsg = strMsg + @"\n\n"; } strMsg = strMsg + @"资产编码[" + lengtherror + "]的条形码长度不是9,所以不能导入。"; } if (existCode.Length > 0) { if (strMsg.Length > 0) { strMsg = strMsg + @"\n\n"; } strMsg = strMsg + @"资产编码[" + existCode + "]已经存在条形码,且资产管理部门为其他部门,所以不能导入。"; } if (noexistClassify.Length > 0) { if (strMsg.Length > 0) { strMsg = strMsg + @"\n\n"; } strMsg = strMsg + @"资产编码[" + noexistClassify + "]对应的资产分类不存在,请在条形码设置画面添加分类后再进行导入操作。"; } if (strMsg.Length > 0) { strMsg = strMsg + @"\n\n"; } strMsg = strMsg + @"共有" + count + "个资产的条形码信息成功导入。"; baseoperation.ShowErrorMessage(this.Page, @strMsg); } else { baseoperation.ShowErrorMessage(this.Page, "该文件为空,没有进行资产的条形码信息更新。"); } } catch (Exception ee) { Log.WriteLog("", ee.ToString()); baseoperation.ShowErrorMessage(this.Page, "上传条形码信息出错,请重新操作。"); } } else { baseoperation.ShowErrorMessage(this.Page, "请选择上传文件。"); } }