Ejemplo n.º 1
0
        public static string GeneralSQL(SQLEnum sqlenum)
        {
            switch (sqlenum)
            {
            case SQLEnum.Insert:
                return(_Insert);

                break;

            case SQLEnum.Update:
                return(_Update);

                break;

            case SQLEnum.Delete:
                return(_Delete);

                break;

            case SQLEnum.Select:
                return(_Select);

                break;

            default:
                throw new Exception("NotDefind SqlType!");
                break;
            }
        }
Ejemplo n.º 2
0
        /// <summary>
        /// 根据json生成对应的sql语句
        /// </summary>
        /// <param name="action">insert 还是 update</param>
        /// <param name="tableName">表名</param>
        /// <param name="primaryKey">主键字段</param>
        /// <param name="obj">json对象</param>
        /// <returns></returns>
        public static string CreateSqlByJsonData(SQLEnum action, string tableName, string primaryKey, JObject obj)
        {
            //sql
            string str = string.Empty;

            //field
            string field = string.Empty;

            //value
            string val = string.Empty;

            int pkid = obj["id"]._ToInt32();

            obj.Remove("id");

            if (action == SQLEnum.INSERT)
            {
                //新增
                foreach (var item in obj)
                {
                    field += item.Key + ",";
                    val   += "'" + item.Value.ToString() + "',";
                }
                field = field.TrimEnd(',');
                val   = val.TrimEnd(',');
                str   = string.Format(action + " into " + tableName + "({0})" + " values({1})", field, val);
            }
            else if (action == SQLEnum.UPDATE)
            {
                //修改
                foreach (var item in obj)
                {
                    if (item.Key.ToString() != primaryKey)
                    {
                        field += item.Key + "='" + item.Value + "',";
                    }
                }
                field = field.TrimEnd(',');
                str   = string.Format(action + " " + tableName + " set {0} where " + primaryKey + "={1}", field, pkid);
            }
            return(str.ToString());
        }