public static string LocationImagePath(clsAccFileinfo location)
{
string basePath = LocationImageBasePath();
string folderPath = Path.Combine(basePath, (Convert.ToInt64(location.accfile_id) / 1000 * 1000).ToString());
CreateFolder(folderPath);
string fullPath = Path.Combine(folderPath, location.File_name);
return(fullPath);
}
private void button1_Click(object sender, EventArgs e)
{
try
{
File_Result = new List <clsFile_Managermentinfo>();
clsFile_Managermentinfo iitem = new clsFile_Managermentinfo();
//iitem.T_id = "1";
iitem.wenjianbiaohao = this.txname.Text;
iitem.biaoti = textBox1.Text;
iitem.wenhao = textBox2.Text;
iitem.zhiwendanwei = textBox3.Text;
iitem.xingwendanwei = textBox4.Text;
iitem.dengjiriqi = this.dateTimePicker1.Value.AddDays(0).Date.ToString("MM/dd/yyyy");;
iitem.miji = textBox6.Text;
iitem.wenjianleibie = textBox7.Text;
iitem.NodeID = tree_Current_row["NodeID"].ToString();
iitem.yeshu = textBox8.Text;
iitem.fenshu = textBox9.Text;
iitem.wenjianqiriqi = this.dateTimePicker3.Value.AddDays(0).Date.ToString("MM/dd/yyyy");;
iitem.wenjianzhiriqi = this.dateTimePicker2.Value.AddDays(0).Date.ToString("MM/dd/yyyy");;
iitem.baoguanqixian = this.comboBox1.Text;
//备注
iitem.beizhu1 = textBox5.Text;
iitem.beizhu2 = textBox10.Text;
iitem.beizhu3 = textBox12.Text;
iitem.beizhu4 = textBox13.Text;
iitem.beizhu5 = textBox14.Text;
string ACCid = clsCommHelp.RandomID();
if (filename.Count > 0)
{
iitem.accfile_id = ACCid;
}
else
{
iitem.accfile_id = "";
}
List <clsAccFileinfo> accFile_Result = new List <clsAccFileinfo>();
for (int i = 0; i < filename.Count; i++)
{
clsAccFileinfo temp = new clsAccFileinfo();
if (i != 0)
{
temp.mark1 += "," + filename[i];
}
else
{
temp.mark1 += filename[i];
}
temp.File_name = System.IO.Path.GetFileName(temp.mark1);
temp.accfile_id = ACCid;
// var strs = System.IO.Directory.GetFiles(temp.mark1.Replace(System.IO.Path.GetFileName(temp.mark1), "")).Where(file => file.ToLower().EndsWith("jpg") || file.ToLower().EndsWith("gif") || file.ToLower().EndsWith("jpeg") || file.ToLower().EndsWith("png")).ToList();
//foreach (string file in strs)
{
//System.IO.FileInfo fi = new System.IO.FileInfo(file);
string serverimg = temp.mark1.Replace(temp.mark1 + "\\", "");
string copyToPath = clsCommHelp.LocationImagePath(temp);
//if (File.Exists(copyToPath))
{
File.Copy(temp.mark1.Replace(",", ""), copyToPath, true);
}
temp.mark1 = copyToPath;
}
accFile_Result.Add(temp);
}
iitem.beizhu = textBox11.Text;
if (iitem1 != null)
{
iitem.T_id = iitem1.T_id;
}
File_Result.Add(iitem);
clsAllnew BusinessHelp = new clsAllnew();
if (iitem1 != null)
{
BusinessHelp.Update_File_detail_Server(File_Result);
BusinessHelp.deleteaccFil(ACCid);
}
else
{
BusinessHelp.InsterFile_detail_Server(File_Result);
}
BusinessHelp.InsteraccFile_Server(accFile_Result);
MessageBox.Show("成功！", "信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
catch (Exception ex)
{
MessageBox.Show("错误！" + ex.Message, "信息", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
throw;
}
}
public List <clsAccFileinfo> find_ACCFile(string text)
{
OleDbConnection aConnection = new OleDbConnection(ConStr);
try
{
List <clsAccFileinfo> dailyResult = new List <clsAccFileinfo>();
if (aConnection.State == ConnectionState.Closed)
{
aConnection.Open();
}
OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(text, aConnection);
OleDbCommandBuilder mybuilder = new OleDbCommandBuilder(myDataAdapter);
DataSet ds = new DataSet();
myDataAdapter.Fill(ds, "AccFile");
foreach (DataRow emp in ds.Tables["AccFile"].Rows)
{
clsAccFileinfo tempnote = new clsAccFileinfo(); //定义返回值
if (emp["T_id"].ToString() != "")
{
tempnote.T_id = emp["T_id"].ToString();
}
if (emp["File_name"].ToString() != "")
{
tempnote.File_name = emp["File_name"].ToString();
}
if (emp["accfile_id"].ToString() != "")
{
tempnote.accfile_id = emp["accfile_id"].ToString();
}
if (emp["mark1"].ToString() != "")
{
tempnote.mark1 = emp["mark1"].ToString();
}
if (emp["mark2"].ToString() != "")
{
tempnote.mark2 = emp["mark2"].ToString();
}
if (emp["mark3"].ToString() != "")
{
tempnote.mark3 = emp["mark3"].ToString();
}
if (emp["mark4"].ToString() != "")
{
tempnote.mark4 = emp["mark4"].ToString();
}
if (emp["mark5"].ToString() != "")
{
tempnote.mark5 = emp["mark5"].ToString();
}
dailyResult.Add(tempnote);
}
return(dailyResult);
}
catch (Exception ex)
{
if (aConnection.State == ConnectionState.Open)
{
aConnection.Close();
}
aConnection.Dispose();
// bgWorker1.ReportProgress(0, "读取失败 ，请刷新后重新读取！");
return(null);
throw ex;
}
finally { if (aConnection.State == ConnectionState.Open)
{
aConnection.Close();
}
aConnection.Dispose(); }
}
