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, "') " }))); }