文件上传到数据库的表中:
static public bool AddSYS_FileData(string sFile_NO,int iFILE_USE,string sFILE_SOURCE,string sFile_BZ,out string sFILE_ID,out string msgError)//新增一筆文件管理記錄
{
string[] sql = new string[1];
string[] tableName = { "SYS_FILES" };
sql[0] = "Select FILE_ID,FILE_NO,FILE_TYPE,FILE_SOURCE,FILE_NAME,FILE_USE,FILE_BZ,Created_by,Creation_date ,Last_update_by ,Last_update_date FROM SYS_FILES Where FILE_NO='" + sFile_NO + "'";
DataSet dsFile = BASEINFO.Query_Data(sql, tableName, out msgError);
if (dsFile != null && dsFile.Tables.Count > 0 && dsFile.Tables [0].Rows .Count ==0)
{
DataRow NewRow = dsFile.Tables["SYS_FILES"].NewRow();
NewRow["FILE_NO"] = sFile_NO;
NewRow["FILE_USE"] = iFILE_USE;
NewRow["FILE_SOURCE"] = sFILE_SOURCE;
NewRow["FILE_BZ"] = sFile_BZ;
NewRow["Created_by"] = Program.userinfo.P_user.U_ID;
NewRow["Creation_date"] = BASEINFO.GetDataBaseDateTime();
NewRow["Last_update_by"] = Program.userinfo.P_user.U_ID;
NewRow["Last_update_date"] = NewRow["Creation_date"];
dsFile.Tables["SYS_FILES"].Rows.Add(NewRow);
if(SaveSYS_FILES(dsFile," AND FILE_NO='" + sFile_NO + "'",out msgError))
{
sFILE_ID = BASEINFO.GetSQLValue("SELECT FILE_ID FROM SYS_FILES Where FILE_NO='" + sFile_NO + "'");
return true;
}
else
{
sFILE_ID = "";
return false;
}
}
else
{
sFILE_ID = "";
return false;
}
}
完整源代码下载链接分享:https://download.csdn.net/download/postfxj/13071295