protected void BtnSave_Click(object sender, DirectEventArgs e) { Y_GBCode _Y_GBCode = new Y_GBCode(); if (Hid.Text.Length > 0) _Y_GBCode = WMSFactory.Y_GBCode.FindById(Hid.Text); //_Y_GBCode.Id = ; //自增 _Y_GBCode.Code = TxtCode.Text; //国标码 _Y_GBCode.StyleId = ""; //新款式编号 bool isok = false; if (Hid.Text.Length > 0) isok = WMSFactory.Y_GBCode.Update(_Y_GBCode); else isok = WMSFactory.Y_GBCode.Add(_Y_GBCode); if (isok) { Y_GBCode_Win.Hide(); Y_GBCode_Grid.Reload(); MsgBox.NotifiShow("恭喜您,操作成功!", "OK"); } else MsgBox.MessageShow("操作失败,请您重试!", "ERROR"); }
protected void BtnSave_Click(object sender, DirectEventArgs e) { Y_GBCode _Y_GBCode = new Y_GBCode(); if (Hid.Text.Length > 0) { _Y_GBCode = WMSFactory.Y_GBCode.FindById(Hid.Text); } //_Y_GBCode.Id = ; //自增 _Y_GBCode.Code = TxtCode.Text; //国标码 _Y_GBCode.StyleId = ""; //新款式编号 bool isok = false; if (Hid.Text.Length > 0) { isok = WMSFactory.Y_GBCode.Update(_Y_GBCode); } else { isok = WMSFactory.Y_GBCode.Add(_Y_GBCode); } if (isok) { Y_GBCode_Win.Hide(); Y_GBCode_Grid.Reload(); MsgBox.NotifiShow("恭喜您,操作成功!", "OK"); } else { MsgBox.MessageShow("操作失败,请您重试!", "ERROR"); } }
//删除数据 protected void BtnDel_Click(object sender, DirectEventArgs e) { int Success = 0, Failed = 0; RowSelectionModel sm = Y_GBCode_Grid.SelectionModel.Primary as RowSelectionModel; foreach (SelectedRow row in sm.SelectedRows) { Y_GBCode _Y_GBCode = new Y_GBCode(); _Y_GBCode.Id = int.Parse(row.RecordID); if (WMSFactory.Y_GBCode.Del(_Y_GBCode)) { Success++; } else { Failed++; } } Y_GBCode_Grid.Reload(); if (Failed > 0) { MsgBox.MessageShow("删除操作完成,成功" + Success.ToString() + "条,失败" + Failed.ToString() + "条!", "OK"); } else { MsgBox.NotifiShow("删除操作完成,成功" + Success.ToString() + "条,失败" + Failed.ToString() + "条!", "OK"); } }
//删除数据 protected void BtnDel_Click(object sender, DirectEventArgs e) { int Success = 0, Failed = 0; RowSelectionModel sm = Y_GBCode_Grid.SelectionModel.Primary as RowSelectionModel; foreach (SelectedRow row in sm.SelectedRows) { Y_GBCode _Y_GBCode = new Y_GBCode(); _Y_GBCode.Id = int.Parse(row.RecordID); if (WMSFactory.Y_GBCode.Del(_Y_GBCode)) Success++; else Failed++; } Y_GBCode_Grid.Reload(); if (Failed > 0) MsgBox.MessageShow("删除操作完成,成功" + Success.ToString() + "条,失败" + Failed.ToString() + "条!", "OK"); else MsgBox.NotifiShow("删除操作完成,成功" + Success.ToString() + "条,失败" + Failed.ToString() + "条!", "OK"); }
//导入 protected void Btnsave_Click(object sender, DirectEventArgs e) { try { string filename = UpFile.PostedFile.FileName; string ext = Path.GetExtension(filename).ToLower(); if (ext != ".xls" && ext != ".xlsx") { X.Msg.Notify("失败", "<font color='red'>文件格式不正确,仅支持.xls(Excel)格式文件!</font>").Show(); return; } filename = DateTime.Now.ToString("yyyyMMddHHmmss") + ext; UpFile.PostedFile.SaveAs(Server.MapPath("File/" + filename)); DataTable dt = new DataTable(); CJ_DevelopHelper.OtherCon_Str = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("File/" + filename) + ";Extended Properties='Excel 8.0;HDR=YES;IMEX=1;'"; CJ_DevelopHelper.SqlStr = "select 国标码,'' as 备注 from [sheet1$] where 国标码<>''"; dt = CJ_DevelopHelper.Other_ReturnDateTable; if (dt.Rows.Count <= 0) { X.Msg.Alert("提醒", "导入的文件无记录!").Show(); return; } DataTable dtCopy = dt.Clone(); for(int i=0;i<dt.Rows.Count;i++) { try { Y_GBCode code = new Y_GBCode(); code.Code = dt.Rows[i]["国标码"].ToString(); code.StyleId = ""; if (!WMSFactory.Y_GBCode.Add(code)) { DataRow newDR = dtCopy.NewRow();//新表创建新行 newDR.ItemArray = dt.Rows[i].ItemArray;//旧表结构行赋给新表结构行 newDR["备注"]="请检查长度或是否已存在该国标码"; dtCopy.Rows.Add(newDR); } } catch (Exception error) { DataRow newDR = dtCopy.NewRow();//新表创建新行 newDR.ItemArray = dt.Rows[i].ItemArray;//旧表结构行赋给新表结构行 newDR["备注"] = "异常:"+error.Message; dtCopy.ImportRow(newDR); } } if (File.Exists(Server.MapPath("File/" + filename))) File.Delete(Server.MapPath("File/" + filename)); Y_GBCode_Grid.Reload(); if (dtCopy.Rows.Count > 0) { string ErrFile = "File/GBK-ERROR-ROWS-" + filename; ExcelHelper.ExportExcelWithAspose(dtCopy, Server.MapPath(ErrFile)); X.Msg.Alert("提醒", "存在错误记录,请先检查!<br />请下载异常文件<a href='" + ErrFile + "' target='_blank'>异常记录</a>,修改后重新上传提交!").Show(); } else { X.Msg.Alert("提醒", "国标码导入成功!").Show(); } } catch (Exception error) { X.Msg.Alert("错误", error.Message + "!请认真检查文档!").Show(); } }
//导入 protected void Btnsave_Click(object sender, DirectEventArgs e) { try { string filename = UpFile.PostedFile.FileName; string ext = Path.GetExtension(filename).ToLower(); if (ext != ".xls" && ext != ".xlsx") { X.Msg.Notify("失败", "<font color='red'>文件格式不正确,仅支持.xls(Excel)格式文件!</font>").Show(); return; } filename = DateTime.Now.ToString("yyyyMMddHHmmss") + ext; UpFile.PostedFile.SaveAs(Server.MapPath("File/" + filename)); DataTable dt = new DataTable(); CJ_DevelopHelper.OtherCon_Str = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("File/" + filename) + ";Extended Properties='Excel 8.0;HDR=YES;IMEX=1;'"; CJ_DevelopHelper.SqlStr = "select 国标码,'' as 备注 from [sheet1$] where 国标码<>''"; dt = CJ_DevelopHelper.Other_ReturnDateTable; if (dt.Rows.Count <= 0) { X.Msg.Alert("提醒", "导入的文件无记录!").Show(); return; } DataTable dtCopy = dt.Clone(); for (int i = 0; i < dt.Rows.Count; i++) { try { Y_GBCode code = new Y_GBCode(); code.Code = dt.Rows[i]["国标码"].ToString(); code.StyleId = ""; if (!WMSFactory.Y_GBCode.Add(code)) { DataRow newDR = dtCopy.NewRow(); //新表创建新行 newDR.ItemArray = dt.Rows[i].ItemArray; //旧表结构行赋给新表结构行 newDR["备注"] = "请检查长度或是否已存在该国标码"; dtCopy.Rows.Add(newDR); } } catch (Exception error) { DataRow newDR = dtCopy.NewRow(); //新表创建新行 newDR.ItemArray = dt.Rows[i].ItemArray; //旧表结构行赋给新表结构行 newDR["备注"] = "异常:" + error.Message; dtCopy.ImportRow(newDR); } } if (File.Exists(Server.MapPath("File/" + filename))) { File.Delete(Server.MapPath("File/" + filename)); } Y_GBCode_Grid.Reload(); if (dtCopy.Rows.Count > 0) { string ErrFile = "File/GBK-ERROR-ROWS-" + filename; ExcelHelper.ExportExcelWithAspose(dtCopy, Server.MapPath(ErrFile)); X.Msg.Alert("提醒", "存在错误记录,请先检查!<br />请下载异常文件<a href='" + ErrFile + "' target='_blank'>异常记录</a>,修改后重新上传提交!").Show(); } else { X.Msg.Alert("提醒", "国标码导入成功!").Show(); } } catch (Exception error) { X.Msg.Alert("错误", error.Message + "!请认真检查文档!").Show(); } }
//查询 protected void BtnSearch_Click(object sender, EventArgs e) { lbInfo.Text = ""; TxtDoType.Text = ""; TxtGBK.Text = ""; TxtGrade.Text = ""; TxtSafeType.Text = ""; try { if (TxtStyleId.Text.Trim().Length <= 0 || TxtColorId.Text.Trim().Length <= 0) { lbInfo.Text = "款式编号和颜色编号不能为空!"; return; } IList <Y_StyleFoundation> style = WMSFactory.Y_StyleFoundation.FindByCondition(string.Format("(StyleId='{0}' OR OldStyleId='{0}') AND (ColorId='{1}' OR OldColorId='{1}')", TxtStyleId.Text.Trim(), TxtColorId.Text.Trim())); if (style.Count <= 0) { lbInfo.Text = "没有找到任何记录!"; return; } Y_StyleFoundation sf = style[0]; //赋值,获取基本信息 lbBrand.Text = sf.BrName; lbdprice.Text = sf.J_Price.ToString(); lbPinM.Text = sf.S_Name; lbCd.Text = sf.Production; lbcf.Text = sf.Fabric == null ? "" : sf.Fabric.Replace(";", "<br />").Replace(";", "<br />"); TxtOldStyleID.Text = sf.OldClothingId; //获取颜色 DataTable dt = WMSFactory.Y_GBCode.Query("SELECT c_name FROM F22.dbo.j_color where colorid='" + sf.ColorId + "'"); if (dt != null && dt.Rows.Count > 0) { lbColor.Text = dt.Rows[0][0].ToString(); } //获取国标码信息 IList <Y_StylePrint> printlist = WMSFactory.Y_StylePrint.FindByCondition("StyleId='" + sf.StyleId + sf.ColorId + "'"); if (printlist.Count > 0) { TxtDoType.Text = printlist[0].DoType; TxtGBK.Text = printlist[0].GBCode; TxtGrade.Text = printlist[0].Grade; TxtSafeType.Text = printlist[0].SafeType; } else {//随机分配一个国标码 IList <Y_GBCode> codeList = WMSFactory.Y_GBCode.FindByCondition(string.Format("StyleId='{0}'", sf.StyleId)); Y_GBCode gbcode = null; if (codeList.Count > 0) { gbcode = codeList[0]; } else { IList <Y_GBCode> codes = WMSFactory.Y_GBCode.FindAllByPage(0, 1, 1, "", "StyleId='' or StyleId is null"); if (codes.Count > 0) { gbcode = codes[0]; } } if (gbcode == null) { lbInfo.Text = "没有可用的国标码了,请上传新的国标码!"; return; } //插入 Y_StylePrint p = new Y_StylePrint(); p.StyleId = sf.StyleId + sf.ColorId; p.GBCode = gbcode.Code; gbcode.StyleId = sf.StyleId;//国标码不到颜色 if (WMSFactory.Y_StylePrint.Add(p) && WMSFactory.Y_GBCode.Update(gbcode)) { TxtGBK.Text = gbcode.Code; } else { lbInfo.Text = "国标码分配失败,请重新单击‘查 询’按钮!"; return; } } //加载尺码信息 RPSize.DataSource = style; RPSize.DataBind(); } catch (Exception error) { lbInfo.Text = "异常:" + error.Message; } }