BLL/TCWL_B_Registration.cs

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

namespace BLL
{
    using Common;
    using DAL;
    using Model;
    using System;
    using System.Data;

    public class TCWL_B_Registration
    {
        private readonly TCWL_D_Registration dal = new TCWL_D_Registration();

        public string AddZhuCe(TCWL_M_Registration model)
        {
            string name = model.Name;
            string contacts = model.Contacts;
            string email = model.Email;
            string phone = model.Phone;
            string serviceID = model.ServiceID;
            string webbrow = model.Webbrow;
            string webVersion = model.WebVersion;
            string addzhuce = "insert into TCWL_All_CompanyInformation(Name,Contacts,Email,phone,ServiceID,sort,Webbrow,WebVersion) values ('" + name + "','" + contacts + "','" + email + "','" + phone + "','" + serviceID + "','00000','" + webbrow + "','" + webVersion + "' )";
            string addbumen = "insert into TCWL_Unit(unitName,parentID,serviceID) values('" + name + "','0','" + serviceID + "')";
            return this.dal.Addzhuce(addzhuce, serviceID, addbumen, contacts, email, phone);
        }

        public string BCUpdate(TCWL_M_Registration model)
        {
            return this.dal.BCUpdate(model).ToString();
        }

        public string DetectionPhone(string phone)
        {
            DataTable table = new DataTable();
            if (this.dal.DetectionPhone(phone).Rows.Count > 0)
            {
                return "exist";
            }
            return "error";
        }

        public string Upbringing()
        {
            int num = 0;
            DataTable dt = this.dal.Upbringing();
            return string.Concat(new object[] { "{\"total\":", num, ",\"rows\":", JsonHelper.DataTableToJson(dt), "}" });
        }

        public string YanZhengYorN()
        {
            return DESEncrypt.Decrypt(this.dal.YanZhengYorN().Rows[0]["State"].ToString());
        }
    }
}