builderbll.cs

一个可以生成代码的插件

                strclass.AppendLine(CreatBLLGetModelByCache(ModelName) );
            }
            if (List)
            {
                strclass.AppendLine(CreatBLLGetList() );
                strclass.AppendLine(CreatBLLGetAllList() );
                strclass.AppendLine(CreatBLLGetListByPage() );
            }

            #endregion
            strclass.AppendSpaceLine(2, "#endregion  成员方法" );
            strclass.AppendSpaceLine(1, "}" );
            strclass.AppendLine("}" );
            strclass.AppendLine("");

            return strclass.ToString();
        }

        #endregion

        #region 具体方法代码

        public string CreatBLLGetMaxID()
        {
            StringPlus strclass = new StringPlus();
            if (_keys.Count > 0)
            {
                string keyname = "";
                foreach (ColumnInfo obj in _keys)
                {
                    if (CodeCommon.DbTypeToCS(obj.TypeName) == "int")
                    {
                        keyname = obj.ColumnName;
                        if (obj.IsPK)
                        {
                            strclass.AppendLine("");
                            strclass.AppendSpaceLine(2, "/// <summary>");
                            strclass.AppendSpaceLine(2, "/// 得到最大ID");
                            strclass.AppendSpaceLine(2, "/// </summary>");
                            strclass.AppendSpaceLine(2, "public int GetMaxId()");
                            strclass.AppendSpaceLine(2, "{");
                            strclass.AppendSpaceLine(3, "return dal.GetMaxId();");
                            strclass.AppendSpaceLine(2, "}");
                            break;
                        }
                    }
                }
            }

            
            return strclass.ToString();
        }
        public string CreatBLLExists()
        {
            StringPlus strclass = new StringPlus();
            if (_keys.Count > 0)
            {
                strclass.AppendSpaceLine(2, "/// <summary>");
                strclass.AppendSpaceLine(2, "/// 是否存在该记录");
                strclass.AppendSpaceLine(2, "/// </summary>");
                strclass.AppendSpaceLine(2, "public bool Exists(" + LTP.CodeHelper.CodeCommon.GetInParameter(Keys) + ")");
                strclass.AppendSpaceLine(2, "{");
                strclass.AppendSpaceLine(3, "return dal.Exists(" + LTP.CodeHelper.CodeCommon.GetFieldstrlist(Keys) + ");");
                strclass.AppendSpaceLine(2, "}");
            }            
            return strclass.ToString();
        }
        public string CreatBLLADD()
        {
            StringPlus strclass = new StringPlus();
            strclass.AppendSpaceLine(2,  "/// <summary>" );
            strclass.AppendSpaceLine(2,  "/// 增加一条数据" );
            strclass.AppendSpaceLine(2,  "/// </summary>" );
            string strretu = "void";
            if ((DbType == "SQL2000" || DbType == "SQL2005") && (IsHasIdentity))
            {
                strretu = "int ";
            }            
            strclass.AppendSpaceLine(2,  "public " + strretu + " Add(" + ModelSpace + " model)" );
            strclass.AppendSpaceLine(2,  "{" );
            if (strretu == "void")
            {
                strclass.AppendSpaceLine(3,  "dal.Add(model);" );
            }
            else
            {
                strclass.AppendSpaceLine(3,  "return dal.Add(model);" );
            }
            strclass.AppendSpaceLine(2,  "}");
            return strclass.ToString();
        }
        public string CreatBLLUpdate()
        {
            StringPlus strclass = new StringPlus();
            strclass.AppendSpaceLine(2,  "/// <summary>" );
            strclass.AppendSpaceLine(2,  "/// 更新一条数据" );
            strclass.AppendSpaceLine(2,  "/// </summary>" );
            strclass.AppendSpaceLine(2,  "public void Update(" + ModelSpace + " model)" );
            strclass.AppendSpaceLine(2,  "{" );
            strclass.AppendSpaceLine(3,  "dal.Update(model);" );
            strclass.AppendSpaceLine(2,  "}");
            return strclass.ToString();
        }
        public string CreatBLLDelete()
        {
            StringPlus strclass = new StringPlus();
            strclass.AppendSpaceLine(2,  "/// <summary>" );
            strclass.AppendSpaceLine(2,  "/// 删除一条数据" );
            strclass.AppendSpaceLine(2,  "/// </summary>" );
            strclass.AppendSpaceLine(2,  "public void Delete(" + LTP.CodeHelper.CodeCommon.GetInParameter(Keys) + ")" );
            strclass.AppendSpaceLine(2,  "{" );
            strclass.AppendSpaceLine(3, KeysNullTip);
            strclass.AppendSpaceLine(3,  "dal.Delete(" + LTP.CodeHelper.CodeCommon.GetFieldstrlist(Keys) + ");" );
            strclass.AppendSpaceLine(2,  "}");
            return strclass.ToString();
        }
        public string CreatBLLGetModel()
        {
            StringPlus strclass = new StringPlus();
            strclass.AppendSpaceLine(2,  "/// <summary>" );
            strclass.AppendSpaceLine(2,  "/// 得到一个对象实体" );
            strclass.AppendSpaceLine(2,  "/// </summary>" );
            strclass.AppendSpaceLine(2,  "public " + ModelSpace + " GetModel(" + LTP.CodeHelper.CodeCommon.GetInParameter(Keys) + ")" );
            strclass.AppendSpaceLine(2,  "{" );
            strclass.AppendSpaceLine(3, KeysNullTip);
            strclass.AppendSpaceLine(3,  "return dal.GetModel(" + LTP.CodeHelper.CodeCommon.GetFieldstrlist(Keys) + ");" );
            strclass.AppendSpaceLine(2,  "}");
            return strclass.ToString();

        }
        public string CreatBLLGetModelByCache(string ModelName)
        {
            StringPlus strclass = new StringPlus();            
            strclass.AppendSpaceLine(2, "/// <summary>" );
            strclass.AppendSpaceLine(2, "/// 得到一个对象实体，从缓存中。");
            strclass.AppendSpaceLine(2, "/// </summary>" );
            strclass.AppendSpaceLine(2, "public " + ModelSpace + " GetModelByCache(" + LTP.CodeHelper.CodeCommon.GetInParameter(Keys) + ")");
            strclass.AppendSpaceLine(2, "{" );
            strclass.AppendSpaceLine(3, KeysNullTip);
            string para = "";
            if (Keys.Count > 0)
            {
                para = "+ " + LTP.CodeHelper.CodeCommon.GetFieldstrlistAdd(Keys);
            }
            strclass.AppendSpaceLine(3, "string CacheKey = \"" + ModelName + "Model-\" " + para + ";");
            strclass.AppendSpaceLine(3, "object objModel = LTP.Common.DataCache.GetCache(CacheKey);");
            strclass.AppendSpaceLine(3, "if (objModel == null)");
            strclass.AppendSpaceLine(3, "{");
            strclass.AppendSpaceLine(4, "try");
            strclass.AppendSpaceLine(4, "{");
            strclass.AppendSpaceLine(5, "objModel = dal.GetModel(" + LTP.CodeHelper.CodeCommon.GetFieldstrlist(Keys) + ");");
            strclass.AppendSpaceLine(5, "if (objModel != null)");
            strclass.AppendSpaceLine(5, "{");
            strclass.AppendSpaceLine(6, "int ModelCache = LTP.Common.ConfigHelper.GetConfigInt(\"ModelCache\");");
            strclass.AppendSpaceLine(6, "LTP.Common.DataCache.SetCache(CacheKey, objModel, DateTime.Now.AddMinutes(ModelCache), TimeSpan.Zero);");
            strclass.AppendSpaceLine(5, "}");
            strclass.AppendSpaceLine(4, "}");
            strclass.AppendSpaceLine(4, "catch{}");
            strclass.AppendSpaceLine(3, "}");
            strclass.AppendSpaceLine(3, "return (" + ModelSpace + ")objModel;");
            strclass.AppendSpaceLine(2, "}");
            return strclass.Value;

        }
        public string CreatBLLGetList()
        {
            StringPlus strclass = new StringPlus();
            //返回DataSet
            strclass.AppendSpaceLine(2,  "/// <summary>" );
            strclass.AppendSpaceLine(2,  "/// 获得数据列表" );
            strclass.AppendSpaceLine(2,  "/// </summary>" );
            strclass.AppendSpaceLine(2,  "public DataSet GetList(string strWhere)" );
            strclass.AppendSpaceLine(2,  "{" );
            strclass.AppendSpaceLine(3,  "return dal.GetList(strWhere);" );
            strclass.AppendSpaceLine(2,  "}");

            //返回List<>
            strclass.AppendSpaceLine(2, "/// <summary>");
            strclass.AppendSpaceLine(2, "/// 获得数据列表");
            strclass.AppendSpaceLine(2, "/// </summary>");
            strclass.AppendSpaceLine(2, "public List<" + ModelSpace + "> GetModelList(string strWhere)");
            strclass.AppendSpaceLine(2, "{");
            strclass.AppendSpaceLine(3, "DataSet ds = dal.GetList(strWhere);");
            strclass.AppendSpaceLine(3, "List<" + ModelSpace + "> modelList = new List<" + ModelSpace + ">();");
            strclass.AppendSpaceLine(3, "int rowsCount = ds.Tables[0].Rows.Count;");
            strclass.AppendSpaceLine(3, "if (rowsCount > 0)");
            strclass.AppendSpaceLine(3, "{");
            strclass.AppendSpaceLine(4, ModelSpace+" model;");
            strclass.AppendSpaceLine(4, "for (int n = 0; n < rowsCount; n++)");
            strclass.AppendSpaceLine(4, "{");
            strclass.AppendSpaceLine(5, "model = new " + ModelSpace + "();");

            #region 字段赋值
            foreach (ColumnInfo field in Fieldlist)
            {
                string columnName = field.ColumnName;
                string columnType = field.TypeName;
                switch (CodeCommon.DbTypeToCS(columnType))
                {
                    case "int":
                        {
                            strclass.AppendSpaceLine(5, "if(ds.Tables[0].Rows[n][\"" + columnName + "\"].ToString()!=\"\")");
                            strclass.AppendSpaceLine(5, "{");
                            strclass.AppendSpaceLine(6, "model." + columnName + "=int.Parse(ds.Tables[0].Rows[n][\"" + columnName + "\"].ToString());");
                            strclass.AppendSpaceLine(5, "}");
                        }
                        break;
                    case "decimal":
                        {
                            strclass.AppendSpaceLine(5, "if(ds.Tables[0].Rows[n][\"" + columnName + "\"].ToString()!=\"\")");
                            strclass.AppendSpaceLine(5, "{");
                            strclass.AppendSpaceLine(6, "model." + columnName + "=decimal.Parse(ds.Tables[0].Rows[n][\"" + columnName + "\"].ToString());");
                            strclass.AppendSpaceLine(5, "}");
                        }
                        break;
                    case "float":
                        {
                            strclass.AppendSpaceLine(5, "if(ds.Tables[0].Rows[n][\"" + columnName + "\"].ToString()!=\"\")");
                            strclass.AppendSpaceLine(5, "{");
                            strclass.AppendSpaceLine(6, "model." + columnName + "=float.Parse(ds.Tables[0].Rows[n][\"" + columnName + "\"].ToString());");
                            strclass.AppendSpaceLine(5, "}");
                        }
                        break;
                    case "DateTime":
                        {
                            strclass.AppendSpaceLine(5, "if(ds.Tables[0].Rows[n][\"" + columnName + "\"].ToString()!=\"\")");
                            strclass.AppendSpaceLine(5, "{");
                            strclass.AppendSpaceLine(6, "model." + columnName + "=DateTime.Parse(ds.Tables[0].Rows[n][\"" + columnName + "\"].ToString());");
                            strclass.AppendSpaceLine(5, "}");
                        }
                        break;
                    case "string":
                        {
                            strclass.AppendSpaceLine(5, "model." + columnName + "=ds.Tables[0].Rows[n][\"" + columnName + "\"].ToString();");
                        }
                        break;
                    case "bool":
                        {
                            strclass.AppendSpaceLine(5, "if(ds.Tables[0].Rows[n][\"" + columnName + "\"].ToString()!=\"\")");
                            strclass.AppendSpaceLine(5, "{");
                            strclass.AppendSpaceLine(6, "if((ds.Tables[0].Rows[n][\"" + columnName + "\"].ToString()==\"1\")||(ds.Tables[0].Rows[n][\"" + columnName + "\"].ToString().ToLower()==\"true\"))");
                            strclass.AppendSpaceLine(6, "{");
                            strclass.AppendSpaceLine(6, "model." + columnName + "=true;");
                            strclass.AppendSpaceLine(6, "}");
                            strclass.AppendSpaceLine(6, "else");
                            strclass.AppendSpaceLine(6, "{");
                            strclass.AppendSpaceLine(7, "model." + columnName + "=false;");
                            strclass.AppendSpaceLine(6, "}");
                            strclass.AppendSpaceLine(5, "}");
                        }
                        break;
                    case "byte[]":
                        {
                            strclass.AppendSpaceLine(5, "if(ds.Tables[0].Rows[n][\"" + columnName + "\"].ToString()!=\"\")");
                            strclass.AppendSpaceLine(5, "{");
                            strclass.AppendSpaceLine(6, "model." + columnName + "=(byte[])ds.Tables[0].Rows[n][\"" + columnName + "\"];");
                            strclass.AppendSpaceLine(5, "}");
                        }
                        break;
                    case "Guid":
                        {
                            strclass.AppendSpaceLine(5, "if(ds.Tables[0].Rows[n][\"" + columnName + "\"].ToString()!=\"\")");
                            strclass.AppendSpaceLine(5, "{");
                            strclass.AppendSpaceLine(6, "model." + columnName + "=new Guid(ds.Tables[0].Rows[n][\"" + columnName + "\"].ToString());");
                            strclass.AppendSpaceLine(5, "}");
                        }
                        break;
                    default:
                        strclass.AppendSpaceLine(5, "//model." + columnName + "=ds.Tables[0].Rows[n][\"" + columnName + "\"].ToString();");
                        break;
                }
            }
            #endregion

            strclass.AppendSpaceLine(5, "modelList.Add(model);");
            strclass.AppendSpaceLine(4, "}");
            strclass.AppendSpaceLine(3, "}");
            strclass.AppendSpaceLine(3, "return modelList;");
            strclass.AppendSpaceLine(2, "}");



            return strclass.ToString();

        }
        public string CreatBLLGetAllList()
        {
            StringPlus strclass = new StringPlus();
            strclass.AppendSpaceLine(2,  "/// <summary>" );
            strclass.AppendSpaceLine(2,  "/// 获得数据列表" );
            strclass.AppendSpaceLine(2,  "/// </summary>" );
            strclass.AppendSpaceLine(2,  "public DataSet GetAllList()" );
            strclass.AppendSpaceLine(2,  "{" );
            strclass.AppendSpaceLine(3,  "return GetList(\"\");" );
            strclass.AppendSpaceLine(2,  "}");
            return strclass.ToString();
        }
        public string CreatBLLGetListByPage()
        {
            StringPlus strclass = new StringPlus();
            strclass.AppendSpaceLine(2,  "/// <summary>" );
            strclass.AppendSpaceLine(2,  "/// 获得数据列表" );
            strclass.AppendSpaceLine(2,  "/// </summary>" );
            strclass.AppendSpaceLine(2,  "//public DataSet GetList(int PageSize,int PageIndex,string strWhere)" );
            strclass.AppendSpaceLine(2,  "//{" );
            strclass.AppendSpaceLine(3,  "//return dal.GetList(PageSize,PageIndex,strWhere);" );
            strclass.AppendSpaceLine(2,  "//}");
            return strclass.ToString();
        }

        #endregion


    }
}