DAL/TCWL_D_GongGaoGuanLi.cs

(开头部分) 12KB

这里只显示每个文件的开头 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_GongGaoGuanLi
    {
        public bool Add(TCWL_M_GongGaoGuanLi model)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("insert into TCWL_GongGaoGuanLi(");
            builder.Append("LeiXing,ServiceID,Title,ContentStr,State,AddUser,Attachment)");
            builder.Append(" values (");
            builder.Append("@LeiXing,@ServiceID,@Title,@ContentStr,@State,@AddUser,@Attachment)");
            SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@LeiXing", SqlDbType.NVarChar, 0x24), new SqlParameter("@ServiceID", SqlDbType.NVarChar, 50), new SqlParameter("@Title", SqlDbType.NVarChar, 100), new SqlParameter("@ContentStr", SqlDbType.Text), new SqlParameter("@State", SqlDbType.SmallInt, 2), new SqlParameter("@AddUser", SqlDbType.NVarChar, 0x24), new SqlParameter("@Attachment", SqlDbType.NVarChar, 200) };
            cmdParms[0].Value = model.LeiXing;
            cmdParms[1].Value = model.ServiceID;
            cmdParms[2].Value = model.Title;
            cmdParms[3].Value = model.ContentStr;
            cmdParms[4].Value = model.State;
            cmdParms[5].Value = model.AddUser;
            cmdParms[6].Value = model.Attachment;
            return (DBHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
        }

        public TCWL_M_GongGaoGuanLi DataRowToModel(DataRow row)
        {
            TCWL_M_GongGaoGuanLi li = new TCWL_M_GongGaoGuanLi();
            if (row != null)
            {
                if (row["ID"] != null)
                {
                    li.ID = row["ID"].ToString();
                }
                if (row["LeiXing"] != null)
                {
                    li.LeiXing = row["LeiXing"].ToString();
                }
                if (row["ServiceID"] != null)
                {
                    li.ServiceID = row["ServiceID"].ToString();
                }
                if ((row["TimeStr"] != null) && (row["TimeStr"].ToString() != ""))
                {
                    li.TimeStr = new DateTime?(DateTime.Parse(row["TimeStr"].ToString()));
                }
                if (row["Title"] != null)
                {
                    li.Title = row["Title"].ToString();
                }
                if (row["ContentStr"] != null)
                {
                    li.ContentStr = row["ContentStr"].ToString();
                }
                if ((row["State"] != null) && (row["State"].ToString() != ""))
后面还有 184 行代码,购买后查看完整代码

24 小时内免费解锁 3 个项目,之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用,每次 10 算力,解读结果公开显示在下面。

还没有人解读过这个文件。