DAL/account/TCWL_D_Account.cs

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

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

namespace DAL.account
{
    using Common;
    using Model.Account;
    using System;
    using System.Data;
    using System.Runtime.InteropServices;

    public class TCWL_D_Account
    {
        public string addBill(TCWL_M_Account m)
        {
            try
            {
                DataTable dataTable = DBHelper.GetDataTable(string.Format("select userXM from TCWL_User where userName='{0}' ", m.createManID));
                if (dataTable.Rows.Count > 0)
                {
                    m.createMan = dataTable.Rows[0][0].ToString();
                }
                else
                {
                    return "noname";
                }
                DBHelper.ExecuteSql(string.Format("insert into TCWL_Acount_Bill (blankCode,doSoming,memo,createMan,createManID,kmNameId,serviceID,money,inOut,happenTime,byperson) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}')",  m.blankCode, m.doSoming, m.memo, m.createMan, m.createManID, m.kmNameId, m.serviceID, m.money, m.inOut, m.happenTime, m.byperson ));
                return "success";
            }
            catch (Exception)
            {
                return "error";
            }
        }

        public string addKM(string serviceid, string kmname)
        {
            try
            {
                DBHelper.ExecuteSql(string.Format("insert into TCWL_Acount_classification (Familiar,ServerID,Belong) values ('{0}','{1}','1')", kmname, serviceid));
                return "success";
            }
            catch (Exception)
            {
                return "error";
            }
        }

        public string delBill(string id)
        {
            try
            {
                DBHelper.ExecuteSql(string.Format("delete from TCWL_Acount_Bill where id='{0}'", id));
                return "success";
            }
            catch (Exception)
            {
                return "error";
            }
        }

        public string editBill(TCWL_M_Account m)
        {