DAL/system/TCWL_D_CloundB.cs

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

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

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

    public class TCWL_D_CloundB
    {
        public DataTable CloundID(string userID)
        {
            DataTable table = new DataTable();
            return DBHelper.GetDataTable("select * from TCWL_B_Lg where UID= '" + userID + "'");
        }

        public string createCInf(string uid, string mm, string bid)
        {
            DataTable table = new DataTable();
            if (DBHelper.GetDataTable(" select * from TCWL_B_Lg where UID = '" + uid + "'").Rows.Count > 0)
            {
                return "exist";
            }
            try
            {
                DBHelper.ExecuteSQL(string.Format("insert into TCWL_B_Lg (UID,BID,BMM) values ('{0}','{1}','{2}')", uid, bid, mm));
                return "success";
            }
            catch (Exception)
            {
                return "error";
            }
        }

        public string DengLu(string userID, string name, string MM)
        {
            DataTable table = new DataTable();
            if (DBHelper.GetDataTable("select * from TCWL_B_Lg where BID= '" + name + "' and BMM = '" + MM + "' ").Rows.Count > 0)
            {
                return "sucess";
            }
            return "error";
        }

        public bool existSame(string numStr)
        {
            return (DBHelper.GetDataTable(string.Format("select top 1 * from TCWL_B_Lg where BID='{0}'", numStr)).Rows.Count > 0);
        }

        public DataTable getCldByBID(string bid)
        {
            try
            {
                return DBHelper.GetDataTable(string.Format("select * from TCWL_B_Lg where BID='{0}'", bid));
            }
            catch (Exception)
            {
                return null;
            }