public static ImportTemplate getTemplate(string tmpName, string type)
{
ImportTemplate tmp;
string[] files = Directory.GetFiles(BasePath, type + "_" + tmpName);
if (files.Length == 0)
{
tmp = new ImportTemplate()
{
FirstRowNum = 0, HasHeadColumn = true, Type = type, Name = "新建模板"
};
}
else
{
BinaryFormatter formmatter = new BinaryFormatter();
Byte[] bytesobject;
using (FileStream sw = new FileStream(files[0], FileMode.Open, FileAccess.Read))
{
bytesobject = new byte[sw.Length];
int rl = sw.Read(bytesobject, 0, (int)sw.Length);
}
MemoryStream stream = new MemoryStream(bytesobject);
tmp = formmatter.Deserialize(stream) as ImportTemplate;
}
return(tmp);
}
public ExcelImport(string filename, string ztname, int zid, string type, ImportTemplate temp)
: base(filename, ztname, zid)
{
this.Template = temp;
this.Type = (DataType)Enum.Parse(typeof(DataType), type);
dt = ExcelLib.NPOIHelper.Excel2DataTable(Filename, Template.HasHeadColumn, 1, Template.FirstRowNum);
}
public ExcelProView(string ExcelFileName, string tmpName, string type, string id)
: this()
{
tmp = TemplateHelper.getTemplate(tmpName, type);
tmp.Id = id;
this.FileName = ExcelFileName;
this.TmpName = tmpName;
this.chkfirstrowiscolname.Checked = tmp.HasHeadColumn;
this.numFirstRow.Value = tmp.FirstRowNum;
showTOP10Excel();
}
public ExcelTemplate(ImportTemplate importtmp)
: this()
{
this.tmp = importtmp;
this.txtTemple.Text = tmp.Name;
this.cmbType.Text = tmp.Type;
if (tmp.Type.ToUpper() == "WPI")
{
chkWPI_AN.Checked = true;
chkWPI_PN.Checked = true;
}
else if (tmp.Type.ToUpper() == "EPODOC")
{
chkEPO_AN.Checked = true;
chkEPO_PN.Checked = true;
}
}
public static bool SaveTemplate(ImportTemplate tmp)
{
BinaryFormatter formmatter = new BinaryFormatter();
MemoryStream stream = new MemoryStream();
Byte[] bytesobject;
formmatter.Serialize(stream, tmp);
bytesobject = stream.ToArray();
using (FileStream sw = new FileStream(BasePath + tmp.Type + "_" + tmp.Name, FileMode.OpenOrCreate, FileAccess.Write))
{
sw.Write(bytesobject, 0, bytesobject.Length);
}
if (tmp.Id != "0")
{
DBA.MySqlDbAccess.ExecNoQuery(System.Data.CommandType.Text, "update cfg_template set name='" + tmp.Name + "',dbtype='" + tmp.Type + "' where id=" + tmp.Id);
}
else
{
DBA.MySqlDbAccess.ExecNoQuery(System.Data.CommandType.Text, "insert into cfg_template (name,dbtype,filetype,path) values ('" + tmp.Name + "','" + tmp.Type + "','xls|xlsx','')");
}
log.Info("保存模板：" + tmp.Name + "\t" + DateTime.Now);
return true;
}
public static ImportTemplate getTemplate(string tmpName, string type)
{
ImportTemplate tmp;
string[] files = Directory.GetFiles(BasePath, type + "_" + tmpName);
if (files.Length == 0)
{
tmp = new ImportTemplate() { FirstRowNum = 0, HasHeadColumn = true, Type = type, Name = "新建模板" };
}
else
{
BinaryFormatter formmatter = new BinaryFormatter();
Byte[] bytesobject;
using (FileStream sw = new FileStream(files[0], FileMode.Open, FileAccess.Read))
{
bytesobject = new byte[sw.Length];
int rl = sw.Read(bytesobject, 0, (int)sw.Length);
}
MemoryStream stream = new MemoryStream(bytesobject);
tmp = formmatter.Deserialize(stream) as ImportTemplate;
}
return tmp;
}
public static bool SaveTemplate(ImportTemplate tmp)
{
BinaryFormatter formmatter = new BinaryFormatter();
MemoryStream stream = new MemoryStream();
Byte[] bytesobject;
formmatter.Serialize(stream, tmp);
bytesobject = stream.ToArray();
using (FileStream sw = new FileStream(BasePath + tmp.Type + "_" + tmp.Name, FileMode.OpenOrCreate, FileAccess.Write))
{
sw.Write(bytesobject, 0, bytesobject.Length);
}
if (tmp.Id != "0")
{
DBA.MySqlDbAccess.ExecNoQuery(System.Data.CommandType.Text, "update cfg_template set name='" + tmp.Name + "',dbtype='" + tmp.Type + "' where id=" + tmp.Id);
}
else
{
DBA.MySqlDbAccess.ExecNoQuery(System.Data.CommandType.Text, "insert into cfg_template (name,dbtype,filetype,path) values ('" + tmp.Name + "','" + tmp.Type + "','xls|xlsx','')");
}
log.Info("保存模板：" + tmp.Name + "\t" + DateTime.Now);
return(true);
}
private void list_template_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex == -1) return;
if (e.ColumnIndex == -1) return;
ztinfo zt = (ztinfo)cmbZTList.SelectedItem;
string type = zt.DbType;
string id = this.dgwtemplate.Rows[e.RowIndex].Cells["Id"].Value.ToString();
string tmpname = this.dgwtemplate.Rows[e.RowIndex].Cells["name"].Value.ToString();
if (Path.GetExtension(this.txtFileName.Text.Trim()).IndexOf(".xls") >= 0)
{
ExcelProView ex = new ExcelProView(this.txtFileName.Text, tmpname, type, id);
if (ex.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
this.tmplate = ex.tmp;
this.txtTemplate.Text = tmplate.Name;
this.panTemplate.Visible = false;
}
}
else
{
this.txtTemplate.Text = tmpname;
this.panTemplate.Visible = false;
}
}
