DAL/TCWL_D_ProcessFormModel.cs

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

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

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

    public class TCWL_D_ProcessFormModel
    {
        public bool Add(TCWL_M_ProcessFormModel model)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("insert into TCWL_ProcessFormModel(");
            builder.Append("PName,PType,PAddUser,PGroup,PShow,PUserId,PUserName,ServiceID,Remarks)");
            builder.Append(" values (");
            builder.Append("@PName,@PType,@PAddUser,@PGroup,@PShow,@PUserId,@PUserName,@ServiceID,@Remarks)");
            SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@PName", SqlDbType.NVarChar, 50), new SqlParameter("@PType", SqlDbType.Int, 4), new SqlParameter("@PAddUser", SqlDbType.VarChar, 10), new SqlParameter("@PGroup", SqlDbType.VarChar, 0xfa0), new SqlParameter("@PShow", SqlDbType.Int, 4), new SqlParameter("@PUserId", SqlDbType.VarChar, 400), new SqlParameter("@PUserName", SqlDbType.NVarChar, 100), new SqlParameter("@ServiceID", SqlDbType.NVarChar, 50), new SqlParameter("@Remarks", SqlDbType.Text) };
            cmdParms[0].Value = model.PName;
            cmdParms[1].Value = model.PType;
            cmdParms[2].Value = model.PAddUser;
            cmdParms[3].Value = model.PGroup;
            cmdParms[4].Value = model.PShow;
            cmdParms[5].Value = model.PUserId;
            cmdParms[6].Value = model.PUserName;
            cmdParms[7].Value = model.ServiceID;
            cmdParms[8].Value = model.Remarks;
            return (DBHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
        }

        public bool Delete(string ID)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("delete from TCWL_ProcessFormModel ");
            builder.Append(" where ID=@ID ");
            SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.VarChar, 0x24) };
            cmdParms[0].Value = ID;
            return (DBHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
        }

        public bool DeleteList(string IDlist)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("delete from TCWL_ProcessFormModel ");
            builder.Append(" where ID in (" + IDlist + ")  ");
            return (DBHelper.ExecuteSql(builder.ToString(), new SqlParameter[0]) > 0);
        }

        public DataTable GetByID(string ID)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("select ID,PName,PType,PGroup,PShow,PUserId,PUserName,Remarks ");
            builder.Append(" FROM TCWL_ProcessFormModel where ID ='" + ID + "'");
            return DBHelper.Query(builder.ToString(), new SqlParameter[0]).Tables[0];
        }

        public DataTable GetList(string strWhere, string user)
        {