DAL/TCWL_D_DevelopmentPlan.cs

（开头部分） 13KB

这里只显示每个文件的开头 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_DevelopmentPlan
    {
        public bool Add(TCWL_M_DevelopmentPlan model)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("insert into TCWL_ZDKaiFaJiHua(");
            builder.Append("JiHuaNeiRong,JiHuaShiJian,JiHuaName,JiHuiBianHao,JiHuaZhuangTai,GongSiID,ServiceID,TimeStr)");
            builder.Append(" values (");
            builder.Append("@JiHuaNeiRong,@JiHuaShiJian,@JiHuaName,@JiHuiBianHao,@JiHuaZhuangTai,@GongSiID,@ServiceID,@TimeStr)");
            SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@JiHuaNeiRong", SqlDbType.NVarChar, 100), new SqlParameter("@JiHuaShiJian", SqlDbType.DateTime), new SqlParameter("@JiHuaName", SqlDbType.NVarChar, 50), new SqlParameter("@JiHuiBianHao", SqlDbType.NVarChar, 50), new SqlParameter("@JiHuaZhuangTai", SqlDbType.NVarChar, 50), new SqlParameter("@GongSiID", SqlDbType.NVarChar, 50), new SqlParameter("@ServiceID", SqlDbType.NVarChar, 50) };
            cmdParms[0].Value = model.JiHuaNeiRong;
            cmdParms[1].Value = model.JiHuaShiJian;
            cmdParms[2].Value = model.JiHuaName;
            cmdParms[3].Value = model.JiHuiBianHao;
            cmdParms[4].Value = model.JiHuaZhuangTai;
            cmdParms[5].Value = model.GongSiID;
            cmdParms[6].Value = model.ServiceID;
            return (DBHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
        }

        public string AddJiHua(TCWL_M_DevelopmentPlan model)
        {
            string sQLJiHua = string.Concat(new object[] { "INSERT INTO TCWL_ZDKaiFaJiHua (JiHuaNeiRong,JiHuaShiJian,JiHuaName,JiHuiBianHao,JiHuaZhuangTai,ServiceID) Values ('", model.JiHuaNeiRong, "','", model.JiHuaShiJian, "','", model.JiHuaName, "','", model.JiHuiBianHao, "','", model.JiHuaZhuangTai, "','", model.ServiceID, "')" });
            string sQLJiHui = "UPDATE TCWL_XiaoShouJiHui SET ZhuangTaiJiHua = '进行中' WHERE ID = '" + model.JiHuiBianHao + "'";
            return DBHelper.Affair(sQLJiHua, sQLJiHui);
        }

        public TCWL_M_DevelopmentPlan DataRowToModel(DataRow row)
        {
            TCWL_M_DevelopmentPlan plan = new TCWL_M_DevelopmentPlan();
            if (row != null)
            {
                if (row["ID"] != null)
                {
                    plan.ID = row["ID"].ToString();
                }
                if (row["JiHuaNeiRong"] != null)
                {
                    plan.JiHuaNeiRong = row["JiHuaNeiRong"].ToString();
                }
                if ((row["JiHuaShiJian"] != null) && (row["JiHuaShiJian"].ToString() != ""))
                {
                    plan.JiHuaShiJian = new DateTime?(DateTime.Parse(row["JiHuaShiJian"].ToString()));
                }
                if (row["JiHuaName"] != null)
                {
                    plan.JiHuaName = row["JiHuaName"].ToString();
                }
                if (row["JiHuiBianHao"] != null)
                {
后面还有 221 行代码，购买后查看完整代码

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

AI 解读 AI

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

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