177 lines
8.8 KiB
C#
177 lines
8.8 KiB
C#
using System;
|
|
using System.Data;
|
|
using System.Configuration;
|
|
using System.Collections;
|
|
using System.Web;
|
|
using System.Web.Security;
|
|
using System.Web.UI;
|
|
using System.Web.UI.WebControls;
|
|
using System.Web.UI.WebControls.WebParts;
|
|
using System.Web.UI.HtmlControls;
|
|
using GThinking.N_MISPRO;
|
|
using GThinking.N_MISPRO.Data;
|
|
using GThinking.N_MODEL.Page;
|
|
using GThinking.N_WORKFLOW;
|
|
using System.Data.Common;
|
|
using GThinking.N_MODEL.Dialog;
|
|
using GThinking.N_PUBLIC;
|
|
using GThinking.N_PUBLIC2;
|
|
using GThinking.N_MISPRO.Utility;
|
|
using System.IO;
|
|
using System.Text;
|
|
using GThinking.N_CONTROL;
|
|
using System.Data.OleDb;
|
|
using GThinking.N_MISPROAS;
|
|
|
|
namespace GThinking.N_XLJC
|
|
{
|
|
public partial class XHMLXQ_DR : SingleCardBase
|
|
{
|
|
XHMLXQ entity = new XHMLXQ();
|
|
protected void Page_Load(object sender, EventArgs e)
|
|
{
|
|
this.UMID = 101421007;
|
|
this.UMName = "导入适用型号电压详情";
|
|
base.CurMaster = Master;
|
|
base.CurEntity = entity;
|
|
this.PageHeight = 180;
|
|
this.PageWidth = 420;
|
|
Master.EnableAttachBtn = false;
|
|
Master.EnableCancelBtn = false;
|
|
Master.EnableCopyBtn = false;
|
|
Master.EnableDeleteBtn = false;
|
|
Master.EnableEditBtn = false;
|
|
Master.EnableInsertBtn = false;
|
|
Master.EnablePrintBtn = false;
|
|
Master.EnableRefreshBtn = false;
|
|
Master.EnableSaveBtn = false;
|
|
fupdPost.FileSaveType = gtAsyncFileUpload.DFileSaveType.SaveToPath;
|
|
if (AppRuntime.BitType == AppBitType.Bit32)
|
|
fupdPost.Filter = "XLS";
|
|
else // AppBitType.Bit64
|
|
fupdPost.Filter = "XLS,XLSX";
|
|
base.InitPage();
|
|
}
|
|
|
|
protected void btnQD_Click(object sender, EventArgs e)
|
|
{
|
|
if (string.IsNullOrEmpty(fupdPost.FilePath.Trim()))
|
|
{
|
|
ShowMessage("请选择需要导入的文件！");
|
|
return;
|
|
}
|
|
try
|
|
{
|
|
try
|
|
{
|
|
string sPath = fupdPost.FilePath;
|
|
string sColumns = "目录型号,目录电压,型号,规格,电压等级,计量单位,显示序号";
|
|
string sMessage = "";
|
|
DataSet aDataExcel = TExcelData.ReadExcel(sPath.Trim(), "sheet1", sColumns, false, ref sMessage);
|
|
if (!sMessage.Trim().Equals(""))
|
|
{
|
|
throw new Exception("导入文件的内容格式不正确，请按帮助文档中要求的内容格式调整导入文件！");
|
|
}
|
|
TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
|
|
TSQL sSQL = new TSQL(dberp);
|
|
dberp.BeginTrans();
|
|
string sDRXXMessage = string.Empty;
|
|
try
|
|
{
|
|
|
|
for (int i = 0; i < aDataExcel.Tables[0].Rows.Count; i++)
|
|
{
|
|
string sMLXHID = aDataExcel.Tables[0].Rows[i][0].ToString().Trim();
|
|
string sMLDYID = aDataExcel.Tables[0].Rows[i][1].ToString().Trim();
|
|
string sXLXHID = aDataExcel.Tables[0].Rows[i][2].ToString().Trim();
|
|
string sXLGGID = aDataExcel.Tables[0].Rows[i][3].ToString().Trim();
|
|
string sDYDJID = aDataExcel.Tables[0].Rows[i][4].ToString().Trim();
|
|
string sJLDW = aDataExcel.Tables[0].Rows[i][5].ToString().Trim();
|
|
string sXSXH = aDataExcel.Tables[0].Rows[i][6].ToString().Trim();
|
|
sSQL.Clear();
|
|
sSQL.Add(@" select XLXSBJXHMLXQ_MLXLXHID
|
|
from XLXSBJXHMLXQ
|
|
where XLXSBJXHMLXQ_MLXLXHID=:XLXSBJXHMLXQ_MLXLXHID and XLXSBJXHMLXQ_MLDYDJID=:XLXSBJXHMLXQ_MLDYDJID and XLXSBJXHMLXQ_XLXHID=:XLXSBJXHMLXQ_XLXHID
|
|
and XLXSBJXHMLXQ_DYDJID=:XLXSBJXHMLXQ_DYDJID and XLXSBJXHMLXQ_XLGGID=:XLXSBJXHMLXQ_XLGGID and XLXSBJXHMLXQ_JLDW=:XLXSBJXHMLXQ_JLDW ");
|
|
|
|
sSQL.ParamByName("XLXSBJXHMLXQ_MLXLXHID").Value = sMLXHID;
|
|
sSQL.ParamByName("XLXSBJXHMLXQ_MLDYDJID").Value = sMLDYID;
|
|
sSQL.ParamByName("XLXSBJXHMLXQ_XLXHID").Value = sXLXHID;
|
|
sSQL.ParamByName("XLXSBJXHMLXQ_DYDJID").Value = sDYDJID;
|
|
sSQL.ParamByName("XLXSBJXHMLXQ_XLGGID").Value = sXLGGID;
|
|
sSQL.ParamByName("XLXSBJXHMLXQ_JLDW").Value = sJLDW;
|
|
if (dberp.OpenDataSet(sSQL).Tables[0].Rows.Count > 0)
|
|
{
|
|
sSQL.Clear();
|
|
sSQL.Add(@"update XLXSBJXHMLXQ set XLXSBJXHMLXQ_MLDYDJID=:XLXSBJXHMLXQ_MLDYDJID,
|
|
XLXSBJXHMLXQ_MLXLXHID=:XLXSBJXHMLXQ_MLXLXHID,
|
|
XLXSBJXHMLXQ_XLXHID=:XLXSBJXHMLXQ_XLXHID,
|
|
XLXSBJXHMLXQ_DYDJID=:XLXSBJXHMLXQ_DYDJID,
|
|
XLXSBJXHMLXQ_XLGGID=:XLXSBJXHMLXQ_XLGGID,
|
|
XLXSBJXHMLXQ_JLDW=:XLXSBJXHMLXQ_JLDW,
|
|
XLXSBJXHMLXQ_WHR=:XLXSBJXHMLXQ_WHR,
|
|
XLXSBJXHMLXQ_WHSJ=:XLXSBJXHMLXQ_WHSJ,
|
|
XLXSBJXHMLXQ_WHRID=:XLXSBJXHMLXQ_WHRID,
|
|
XLXSBJXHMLXQ_XSXH=:XLXSBJXHMLXQ_XSXH
|
|
where XLXSBJXHMLXQ_MLXLXHID=:XLXSBJXHMLXQ_MLXLXHID and XLXSBJXHMLXQ_MLDYDJID=:XLXSBJXHMLXQ_MLDYDJID and XLXSBJXHMLXQ_XLXHID=:XLXSBJXHMLXQ_XLXHID
|
|
and XLXSBJXHMLXQ_DYDJID=:XLXSBJXHMLXQ_DYDJID and XLXSBJXHMLXQ_XLGGID=:XLXSBJXHMLXQ_XLGGID and XLXSBJXHMLXQ_JLDW=:XLXSBJXHMLXQ_JLDW ");
|
|
|
|
}
|
|
else
|
|
{
|
|
sSQL.Clear();
|
|
sSQL.Add(@"insert into XLXSBJXHMLXQ(XLXSBJXHMLXQ_MLXLXHID,XLXSBJXHMLXQ_MLDYDJID,XLXSBJXHMLXQ_XLXHID,XLXSBJXHMLXQ_DYDJID,XLXSBJXHMLXQ_XLGGID,XLXSBJXHMLXQ_JLDW,
|
|
XLXSBJXHMLXQ_WHR,XLXSBJXHMLXQ_WHSJ,XLXSBJXHMLXQ_WHRID,XLXSBJXHMLXQ_XSXH)
|
|
values(:XLXSBJXHMLXQ_MLXLXHID,:XLXSBJXHMLXQ_MLDYDJID,:XLXSBJXHMLXQ_XLXHID,:XLXSBJXHMLXQ_DYDJID,:XLXSBJXHMLXQ_XLGGID,:XLXSBJXHMLXQ_JLDW,
|
|
:XLXSBJXHMLXQ_WHR,:XLXSBJXHMLXQ_WHSJ,:XLXSBJXHMLXQ_WHRID,:XLXSBJXHMLXQ_XSXH )");
|
|
|
|
}
|
|
|
|
sSQL.ParamByName("XLXSBJXHMLXQ_MLXLXHID").Value = sMLXHID;
|
|
sSQL.ParamByName("XLXSBJXHMLXQ_MLDYDJID").Value = sMLDYID;
|
|
sSQL.ParamByName("XLXSBJXHMLXQ_XLXHID").Value = sXLXHID;
|
|
sSQL.ParamByName("XLXSBJXHMLXQ_DYDJID").Value = sDYDJID;
|
|
sSQL.ParamByName("XLXSBJXHMLXQ_XLGGID").Value = sXLGGID;
|
|
sSQL.ParamByName("XLXSBJXHMLXQ_JLDW").Value = sJLDW;
|
|
sSQL.ParamByName("XLXSBJXHMLXQ_XSXH").Value = CMISproConvert.StrToFloat(sXSXH,0);
|
|
sSQL.ParamByName("XLXSBJXHMLXQ_WHRID").Value = tSession.UserId;
|
|
sSQL.ParamByName("XLXSBJXHMLXQ_WHR").Value = tSession.UserName;
|
|
sSQL.ParamByName("XLXSBJXHMLXQ_WHSJ").Value = DateTime.Now;
|
|
|
|
|
|
|
|
dberp.ExecSQL(sSQL);
|
|
}
|
|
dberp.CommitTrans();
|
|
|
|
ShowMessage("导入成功！");
|
|
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
dberp.RollbackTrans();
|
|
throw new Exception("导入失败，错误信息：" + ex.Message);
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
ShowMessage("导入失败，错误信息：" + ex.Message);
|
|
return;
|
|
}
|
|
System.IO.File.Delete(fupdPost.FilePath.Trim());
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
ShowMessage("导入失败，错误信息：" + ex.Message);
|
|
return;
|
|
}
|
|
CloseWindowNoQuery();
|
|
}
|
|
|
|
protected void btnQX_Click(object sender, EventArgs e)
|
|
{
|
|
CloseWindowNoQuery();
|
|
}
|
|
}
|
|
}
|