CY_ZZJY.BO/Bus/T_CHECKER_BLL.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using CY_ZZJY.IService.Bus;
using Hxj.Data;
using CY_ZZJY.Model.Sys;
using CY_ZZJY.EasyUI;
using System.Data;
using CY_ZZJY.Model.Bus;

namespace CY_ZZJY.BO.Bus
{
    /// <summary>
    /// 检验员
    /// </summary>
    public class T_CHECKER_BLL : T_CHECKER_IService
    {
        #region 录入
        /// <summary>
        /// 新增或修改
        /// </summary>
        /// <param name="action">add、edit</param>
        /// <param name="model">实体类</param>
        /// <returns>true：成功,false：失败</returns>
        public bool AddOrEdit(string action, Entity model)
        {
            bool flag = false;
            Mdl_T_CHECKER _Mdl_T_CHECKER = (Mdl_T_CHECKER)model;
            Dictionary<string, object> keyvalue = StaticClass.GetKeyValue(model);
            string sql = string.Empty;
            string sql_key = string.Empty;
            string sql_value = string.Empty;
            if (action == "add")
            {
                sql += string.Format("INSERT INTO {0} ", "T_CHECKER");
                sql_key += " ( ";
                sql_value += " ( ";
                foreach (KeyValuePair<string, object> kv in keyvalue)
                {
                    sql_key += string.Format("{0},", StaticClass.CheckColumnName(kv.Key));
                    sql_value += string.Format("{0},", kv.Value.ToString());
                }
                if (!string.IsNullOrEmpty(sql_key))
                    sql_key = sql_key.Substring(0, sql_key.Length - 1);
                sql_key += " ) ";
                if (!string.IsNullOrEmpty(sql_value))
                    sql_value = sql_value.Substring(0, sql_value.Length - 1);
                sql_value += " ) ";
                sql += string.Format("{0} VALUES {1}", sql_key, sql_value);
            }
            else if (action == "edit")
            {
                sql += string.Format("UPDATE {0} SET ", "T_CHECKER");
                foreach (KeyValuePair<string, object> kv in keyvalue)
                {
                    if (kv.Key != "ID")
                        sql_key += string.Format("{0}={1},", StaticClass.CheckColumnName(kv.Key), kv.Value);
                }
                if (sql_key.Length > 0)