DAL/TCWL_D_CollectionPlan.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_CollectionPlan
    {
        public bool Add(TCWL_M_CollectionPlan model)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("insert into TCWL_Contract_Receivables(");
            builder.Append("parentID,dueDates,receivedAmount,Percentage,State,ServiceID,NeiRong,Beizhu)");
            builder.Append(" values (");
            builder.Append("@parentID,@dueDates,@receivedAmount,@Percentage,@State,@ServiceID,@NeiRong,@Beizhu)");
            SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@parentID", SqlDbType.NVarChar, 0x24), new SqlParameter("@dueDates", SqlDbType.DateTime), new SqlParameter("@receivedAmount", SqlDbType.Float, 8), new SqlParameter("@Percentage", SqlDbType.NVarChar, 50), new SqlParameter("@State", SqlDbType.NVarChar, 50), new SqlParameter("@ServiceID", SqlDbType.NVarChar, 50), new SqlParameter("@NeiRong", SqlDbType.NVarChar, 50), new SqlParameter("@Beizhu", SqlDbType.NVarChar, 50) };
            cmdParms[0].Value = model.parentID;
            cmdParms[1].Value = model.dueDates;
            cmdParms[2].Value = model.receivedAmount;
            cmdParms[3].Value = model.Percentage;
            cmdParms[4].Value = model.State;
            cmdParms[5].Value = model.ServiceID;
            cmdParms[6].Value = model.neirong;
            cmdParms[7].Value = model.beizhu;
            return (DBHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
        }

        public TCWL_M_CollectionPlan DataRowToModel(DataRow row)
        {
            TCWL_M_CollectionPlan plan = new TCWL_M_CollectionPlan();
            if (row != null)
            {
                if (row["ID"] != null)
                {
                    plan.ID = row["ID"].ToString();
                }
                if (row["parentID"] != null)
                {
                    plan.parentID = row["parentID"].ToString();
                }
                if ((row["dueDates"] != null) && (row["dueDates"].ToString() != ""))
                {
                    plan.dueDates = new DateTime?(DateTime.Parse(row["dueDates"].ToString()));
                }
                if ((row["receivedAmount"] != null) && (row["receivedAmount"].ToString() != ""))
                {
                    plan.receivedAmount = new decimal?(decimal.Parse(row["receivedAmount"].ToString()));
                }
                if (row["Percentage"] != null)
                {
                    plan.Percentage = row["Percentage"].ToString();
                }
                if (row["ServiceID"] != null)
                {
                    plan.ServiceID = row["ServiceID"].ToString();
                }