DAL/TCWL_D_FileManagement.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

namespace DAL
{
    using Common;
    using Model;
    using System;
    using System.Configuration;
    using System.Data;
    using System.Data.SqlClient;
    using System.Runtime.InteropServices;
    using System.Text;

    public class TCWL_D_FileManagement
    {
        public string Add(TCWL_M_FileManagement model)
        {
            string str = "";
            string[] strArray = model.AttachFile.Split(new char[] { '╯' });
            string[] strArray2 = model.FTitle.Split(new char[] { '╯' });
            string[] strArray3 = model.FCategory.Split(new char[] { '╯' });
            for (int i = 0; i < strArray.Length; i++)
            {
                string str3 = str;
                str = str3 + "insert into TCWL_FileManagement(FTitle,FParentID,FType,FCategory,FSort,ShareUserID,ShareUserName,Memor,AttachFile,PubPerson,FileTag,ServiceID) values ('" + strArray2[i].ToString() + "','" + model.FParentID + "','" + model.FType + "','" + strArray3[i] + "','" + model.FSort + "','" + model.ShareUserID + "','" + model.ShareUserName + "','" + model.Memor + "','" + strArray[i].ToString() + "','" + model.PubPerson + "','" + model.FileTag + "','" + model.ServiceID + "');";
            }
            if (DBHelper.ExecuteSql(str.ToString(), new SqlParameter[0]) > 0)
            {
                return "sucess";
            }
            return "error";
        }

        public string Add_fl(TCWL_M_FileManagement model)
        {
            DataTable dataTable = new DataTable();
            dataTable = DBHelper.GetDataTable("select ID,FTitle from TCWL_FileManagement where FTitle='" + model.FTitle + "' and FSort='" + model.FSort + "'");
            if ((dataTable.Rows.Count > 0) && (dataTable != null))
            {
                return "name";
            }
            StringBuilder builder = new StringBuilder();
            builder.Append("insert into TCWL_FileManagement ( ");
            builder.Append("FTitle,ServiceID,PubPerson,FSort,FileTag,ShareUserID ");
            builder.Append(" ) values (");
            builder.Append("@FTitle,@ServiceID,@PubPerson,@FSort,@FileTag,@ShareUserID )");
            SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@FTitle", SqlDbType.NVarChar, 200), new SqlParameter("@ServiceID", SqlDbType.NVarChar, 50), new SqlParameter("@PubPerson", SqlDbType.NVarChar, 50), new SqlParameter("@FSort", SqlDbType.NVarChar, 50), new SqlParameter("@FileTag", SqlDbType.NVarChar, 500), new SqlParameter("@ShareUserID", SqlDbType.Text) };
            cmdParms[0].Value = model.FTitle;
            cmdParms[1].Value = model.ServiceID;
            cmdParms[2].Value = model.PubPerson;
            cmdParms[3].Value = model.FSort;
            cmdParms[4].Value = model.FileTag;
            cmdParms[5].Value = model.ShareUserID;
            if (DBHelper.ExecuteSql(builder.ToString(), cmdParms) > 0)
            {
                return "sucess";
            }
            return "error";
        }

        public string Delete(string ID)
        {