public int ProjectfilesUp(ProjectFilesUpInfo pfui, string FilesID)
{
string str2 = "update Prj_Files set FilesName = '" + pfui.FilesName.ToString() + "',ArchivingID='" + pfui.ArchivingID.ToString() + "',";
object obj2 = str2 + " ArchivingCode='" + pfui.ArchivingCode.ToString() + "',JuanCode = '" + pfui.JuanCode.ToString() + "',ArchivingName = '" + pfui.ArchivingName.ToString() + "', ";
string str3 = string.Concat(new object[] { obj2, " SaveAddress = '", pfui.SaveAddress.ToString(), "', IsArchiving = ", pfui.IsArchiving ? 1 : 0, ",ClassID = '", pfui.ClassID.ToString(), "'" });
return(publicDbOpClass.ExecSqlString((str3 + ",Remark='" + pfui.Remark + "',ImagingPath='" + pfui.ImagingUrl + "' ") + "where FilesID = '" + FilesID + "'"));
}
public int ProjectfilesUpInsert(ProjectFilesUpInfo pfui)
{
string str = "insert into Prj_Files (FilesID,FilesName,PriCode,ArchivingID,ArchivingCode,JuanCode,ArchivingName,IsArchiving,SaveAddress,ClassID,Remark,Actor,ScheduleCode,ImagingPath)";
object obj2 = str;
return(publicDbOpClass.ExecSqlString(string.Concat(new object[] {
obj2, "values('", pfui.FilesID, "','", pfui.FilesName, "','", pfui.PriCode, "','", pfui.ArchivingID, "','", pfui.ArchivingCode, "','", pfui.JuanCode, "','", pfui.ArchivingName, "',0,'",
pfui.SaveAddress, "','", pfui.ClassID, "','", pfui.Remark, "','", pfui.Actor, "','", pfui.ScheduleCode, "','", pfui.ImagingUrl, "') "
})));
}
