首页 新闻 搜索 专区 学院

codesmith生成代码问题

0
悬赏园豆:50 [已解决问题] 解决于 2012-11-16 11:17

我想问一下业务数据库有32张表,那么BLL  IDAL  DAL  MODEL层要各写32个模版吗即128个模版吗? 还有生成的代码怎麽自动生成cs文件,然后把生成的代码输出到cs文件里面,在网上找了一篇文章 试过不行 文章地址:http://terrylee.cnblogs.com/archive/2005/12/28/306233.html

本人是codesmith初学者希望各位大侠帮忙 还有希望可以根据我下面给出的cs文件给出codesmith模版,谢谢大家了

  1 ------CT_Append_BLL.cs---------------------------------------------------------------------
  2 // =================================================================== 
  3 // Name: DataAccess Factory
  4 // Author: 小华
  5 // DateTime: 2011-07-08
  6 // Description: DataAccess.cs
  7 // =================================================================== 
  8 using System;
  9 using System.Collections.Generic;
 10 using GPOS.Components;
 11 using GPOS.Model;
 12 using GPOS.IDAL;
 13 using GPOS.DALFactory;
 14 
 15 namespace GPOS.BLL
 16 {
 17     public class CT_Append
 18     {
 19         private static readonly ICT_Append dal = DataAccess.CreateCT_Append();
 20 
 21         // <summary>
 22         // 添加充值
 23         // </summary>
 24         // <param name="CT_AppendInfo">充值信息</param>
 25         // <returns></returns>
 26         public static int Create(CT_AppendInfo _CT_AppendInfo)
 27         {
 28             if (_CT_AppendInfo == null)
 29                 return 0;
 30             else
 31                 return dal.Create(_CT_AppendInfo);
 32 
 33         }
 34 
 35 
 36         // <summary>
 37         // 删除充值记录
 38         // </summary>
 39         // <param name="vC_A_SNNO">充值交易序号</param>
 40         // <returns></returns>
 41         public static int Remove(string vC_A_SNNO)
 42         {
 43                 return dal.Remove(vC_A_SNNO);
 44 
 45         }
 46 
 47         // <summary>
 48         // 根据交易序号获取一条充值信息
 49         // </summary>
 50         // <param name="vC_A_SNNO">充值交易序号</param>
 51         // <returns></returns>
 52         public static CT_AppendInfo GetById(string vC_A_SNNO)
 53         {
 54                 return dal.GetById(vC_A_SNNO);
 55 
 56         }
 57 
 58         // <summary>
 59         // 获取一个分页列表
 60         // </summary>
 61         // <param name="TotalRecords">行数</param>
 62         // <param name="PageIndex">索引</param>
 63         // <returns></returns>
 64         public static PageSetInfo Get(int TotalRecords, int PageIndex)
 65         {
 66             if (TotalRecords > 0 && PageIndex > 0)
 67                 return dal.Get(TotalRecords, PageIndex);
 68             else
 69                 return null;
 70         }
 71 
 72 
 73         /// <summary>
 74         /// 查询充值记录
 75         /// </summary>
 76         /// <param name="VC_A_SNNO">充值交易序号</param>
 77         /// <param name="VC_OC_UserName">客户名称</param> 
 78         /// <param name="VC_OC_Company">单位</param>
 79         /// <param name="VC_A_CardNO">卡号</param>
 80         /// <param name="CardType">卡片类型</param>
 81         /// <param name="VC_A_AppendType">充值类型</param>
 82         /// <param name="VC_TicketType">发票类型</param>
 83         /// <param name="VC_TicketNO">发票编号</param>
 84         /// <param name="StartDate">开始日期</param>
 85         /// <param name="EndDate">结束日期</param>
 86         /// <param name="TotalRecords">每页的条数</param>
 87         /// <param name="PageIndex">页数</param>
 88         /// <returns></returns>
 89         public static PageSetInfo Search(string VC_A_SNNO, string VC_OC_UserName, string VC_OC_Company, string VC_A_CardNO, int CardType, string VC_A_AppendType, string VC_TicketType, string VC_TicketNO, string StartDate, string EndDate, int TotalRecords, int PageIndex)
 90         {
 91             return dal.Search(VC_A_SNNO, VC_OC_UserName, VC_OC_Company, VC_A_CardNO, CardType, VC_A_AppendType, VC_TicketType,
 92                               VC_TicketNO, StartDate, EndDate, TotalRecords, PageIndex);
 93         }
 94         /// <summary>
 95         /// 客户IC卡充值明细报表查询
 96         /// </summary>
 97         /// <param name="VC_A_CardNO">客户卡号</param>
 98         /// <param name="VC_OC_UserName">客户名称</param>
 99         /// <param name="VC_OC_Company">客户单位</param>

100         /// <param name="I_A_CardType">卡片类型</param>
101         /// <param name="StartDate">开始日期</param>
102         /// <param name="EndDate">结束日期</param>
103         /// <param name="TotalRecords">每页的记录数</param>
104         /// <param name="PageIndex">当前页数</param>
105         /// <returns></returns>
106         public static PageSetInfo Search(string VC_A_CardNO, string VC_OC_UserName, string VC_OC_Company, int I_A_CardType, string StartDate, string EndDate, int TotalRecords, int PageIndex)
107         {
108             return Search("", VC_OC_UserName, VC_OC_Company, VC_A_CardNO, I_A_CardType, "", "", "", StartDate, EndDate, TotalRecords,
109                           PageIndex);
110         }
111     }
112 }
  1 ---------CT_Append_DAL.cs------------------------------------------------------------------
  2 // =================================================================== 
  3 // Name: CT_Append Data Layers
  4 // Author: 小华
  5 // DateTime: 2011-07-08
  6 // Description: CT_Append.cs
  7 // =================================================================== 
  8 using System;
  9 using System.Collections.Generic;
 10 using System.Data;
 11 using System.Data.SqlClient;
 12 using GPOS.Components;
 13 using GPOS.Model;
 14 using GPOS.IDAL;
 15 
 16 namespace GPOS.DAL
 17 {
 18     public class CT_Append : ICT_Append
 19     {
 20         private readonly string connectionString = ForumConfig.ReadConfigInfo().DataBase;
 21 
 22         // <summary>
 23         // Create a records
 24         // </summary>
 25         // <param name="CT_AppendInfo">Model::CT_AppendInfo</param>
 26         // <returns></returns>
 27         public int Create(CT_AppendInfo _CT_AppendInfo)
 28         {
 29             int ret = -1;
 30             SqlConnection myConnection = new SqlConnection(connectionString);
 31             SqlCommand myCommand = new SqlCommand("CT_Append_Create", myConnection);
 32 
 33             myCommand.CommandType = CommandType.StoredProcedure;
 34 
 35             myCommand.Parameters.Add("@VC_A_SNNO", SqlDbType.VarChar, 50).Value = _CT_AppendInfo.VC_A_SNNO;
 36             myCommand.Parameters.Add("@VC_A_AppendType", SqlDbType.VarChar, 50).Value = _CT_AppendInfo.VC_A_AppendType;
 37             myCommand.Parameters.Add("@VC_A_CardNO", SqlDbType.VarChar, 50).Value = _CT_AppendInfo.VC_A_CardNO;
 38             myCommand.Parameters.Add("@I_A_CardType", SqlDbType.Int).Value = _CT_AppendInfo.I_A_CardType;
 39             myCommand.Parameters.Add("@I_A_PointToOil", SqlDbType.Int).Value = _CT_AppendInfo.I_A_PointToOil;
 40             myCommand.Parameters.Add("@VC_TicketType", SqlDbType.VarChar, 50).Value = _CT_AppendInfo.VC_TicketType;
 41             myCommand.Parameters.Add("@VC_TicketNO", SqlDbType.VarChar, 50).Value = _CT_AppendInfo.VC_TicketNO;
 42             myCommand.Parameters.Add("@DE_A_BAmount", SqlDbType.Decimal).Value = _CT_AppendInfo.DE_A_BAmount;
 43             myCommand.Parameters.Add("@DE_A_AppendAmount", SqlDbType.Decimal).Value = _CT_AppendInfo.DE_A_AppendAmount;
 44             myCommand.Parameters.Add("@DE_A_AAmount", SqlDbType.Decimal).Value = _CT_AppendInfo.DE_A_AAmount;
 45             myCommand.Parameters.Add("@D_A_AppendDateTime", SqlDbType.DateTime).Value = _CT_AppendInfo.D_A_AppendDateTime;
 46             myCommand.Parameters.Add("@VC_A_Remark", SqlDbType.VarChar, 256).Value = _CT_AppendInfo.VC_A_Remark;
 47             myCommand.Parameters.Add("@VC_A_OperatorNO", SqlDbType.VarChar, 50).Value = _CT_AppendInfo.VC_A_OperatorNO;
 48 
 49             myConnection.Open();
 50             try
 51             {
 52                 ret = Convert.ToInt32(myCommand.ExecuteScalar());
 53             }
 54             catch (Exception ex)
 55             {
 56                 WriteDataErrLog.WriteDataErrDetail(myCommand, ex.ToString());
 57                
 58             }
 59             myConnection.Close();
 60 
 61             return ret;
 62         }
 63 
 64 
 65 
 66         // <summary>
 67         // Delete a records
 68         // </summary>
 69         // <param name="vC_A_SNNO">string::vC_A_SNNO</param>
 70         // <returns></returns>
 71         public int Remove(string vC_A_SNNO)
 72         {
 73             int ret = -1;
 74             SqlConnection myConnection = new SqlConnection(connectionString);
 75             SqlCommand myCommand = new SqlCommand("CT_Append_Remove", myConnection);
 76 
 77             myCommand.CommandType = CommandType.StoredProcedure;
 78 
 79             myCommand.Parameters.Add("@VC_A_SNNO", SqlDbType.VarChar).Value = vC_A_SNNO;
 80 
 81             myConnection.Open();
 82             try
 83             {
 84                 ret = Convert.ToInt32(myCommand.ExecuteScalar());
 85             }
 86             catch (Exception ex)
 87             {
 88                 WriteDataErrLog.WriteDataErrDetail(myCommand, ex.ToString());
 89                 
 90             }
 91 
 92             myConnection.Close();
 93 
 94             return ret;
 95         }
 96 
 97         // <summary>
 98         // Get a records
 99         // </summary>
100         // <param name="vC_A_SNNO">string::vC_A_SNNO</param>
101         // <returns></returns>
102         public CT_AppendInfo GetById(string vC_A_SNNO)
103         {
104             SqlConnection myConnection = new SqlConnection(connectionString);
105             SqlCommand myCommand = new SqlCommand("CT_Append_GetByVC_A_SNNO", myConnection);
106 
107             myCommand.CommandType = CommandType.StoredProcedure;
108             myCommand.Parameters.Add("@VC_A_SNNO", SqlDbType.VarChar).Value = vC_A_SNNO;
109 
110             myConnection.Open();
111 
112             CT_AppendInfo _CT_AppendInfo2 = new CT_AppendInfo();
113             SqlDataReader dr = myCommand.ExecuteReader();
114 
115             while (dr.Read())
116                 _CT_AppendInfo2 = Populate(dr);
117 
118             dr.Close();
119             myConnection.Close();
120 
121             return _CT_AppendInfo2;
122         }
123 
124 
125         // <summary>
126         // Get List
127         // </summary>
128         // <param name="TotalRecords">Int::TotalRecords</param>
129         // <param name="PageSize">Int::PageSize</param>
130         // <returns></returns>
131         public PageSetInfo Get(int TotalRecords, int PageIndex)
132         {
133             SqlConnection myConnection = new SqlConnection(connectionString);
134             SqlCommand myCommand = new SqlCommand("CT_Append_Get", myConnection);
135 
136             myCommand.CommandType = CommandType.StoredProcedure;
137 
138             myCommand.Parameters.Add("@TotalRecords", SqlDbType.Int).Value = TotalRecords;
139             myCommand.Parameters.Add("@PageIndex", SqlDbType.Int).Value = PageIndex;
140 
141             myConnection.Open();
142 
143             PageSetInfo _CT_AppendSetInfo = new PageSetInfo();
144             try
145             {
146                 SqlDataReader dr = myCommand.ExecuteReader();
147 
148                 while (dr.Read())
149                     _CT_AppendSetInfo.CT_AppendInfo.Add(Populate(dr));
150 
151                 dr.NextResult();
152 
153                 while (dr.Read())
154                     _CT_AppendSetInfo.TotalRecords = Convert.ToInt32(dr["TotalRecords"]);
155 
156                 dr.Close();
157             }
158             catch (Exception ex)
159             {
160                 WriteDataErrLog.WriteDataErrDetail(myCommand, ex.ToString());
161                 
162             }
163 
164             myConnection.Close();
165 
166             return _CT_AppendSetInfo;
167         }
168 
169         /// <summary>
170         /// 查询充值记录
171         /// </summary>
172         /// <param name="VC_A_SNNO">充值交易序号</param>
173         /// <param name="VC_OC_UserName">客户名称</param> 
174         /// <param name="VC_OC_Company">单位</param>
175         /// <param name="VC_A_CardNO">卡号</param>
176         /// <param name="CardType">卡片类型</param>
177         /// <param name="VC_A_AppendType">充值类型</param>
178         /// <param name="VC_TicketType">发票类型</param>
179         /// <param name="VC_TicketNO">发票编号</param>
180         /// <param name="StartDate">开始日期</param>
181         /// <param name="EndDate">结束日期</param>
182         /// <param name="TotalRecords">每页的条数</param>
183         /// <param name="PageIndex">页数</param>
184         /// <returns></returns>
185         public PageSetInfo Search(string VC_A_SNNO,string VC_OC_UserName,string VC_OC_Company,string VC_A_CardNO,int CardType,string VC_A_AppendType,string VC_TicketType,string VC_TicketNO, string StartDate, string EndDate, int TotalRecords, int PageIndex)
186         {
187             SqlConnection myConnection = new SqlConnection(connectionString);
188             SqlCommand myCommand = new SqlCommand("CT_Append_Search", myConnection);
189 
190             myCommand.CommandType = CommandType.StoredProcedure;
191 
192             myCommand.Parameters.Add("@VC_A_SNNO", SqlDbType.VarChar).Value = VC_A_SNNO;
193             myCommand.Parameters.Add("@VC_OC_UserName", SqlDbType.VarChar).Value = VC_OC_UserName;
194             myCommand.Parameters.Add("@VC_OC_Company", SqlDbType.VarChar).Value = VC_OC_Company;
195             myCommand.Parameters.Add("@VC_A_CardNO", SqlDbType.VarChar).Value = VC_A_CardNO;
196             myCommand.Parameters.Add("@CardType", SqlDbType.Int).Value = CardType;
197             myCommand.Parameters.Add("@VC_A_AppendType", SqlDbType.VarChar).Value = VC_A_AppendType;
198             myCommand.Parameters.Add("@VC_TicketType", SqlDbType.VarChar).Value = VC_TicketType;
199             myCommand.Parameters.Add("@VC_TicketNO", SqlDbType.VarChar).Value = VC_TicketNO;
200             myCommand.Parameters.Add("@StartDate", SqlDbType.VarChar).Value = StartDate;
201             myCommand.Parameters.Add("@EndDate", SqlDbType.VarChar).Value = EndDate;
202             myCommand.Parameters.Add("@TotalRecords", SqlDbType.Int).Value = TotalRecords;
203             myCommand.Parameters.Add("@PageIndex", SqlDbType.Int).Value = PageIndex;
204 
205             myConnection.Open();
206             PageSetInfo _CT_AppendSetInfo = new PageSetInfo();
207             try
208             {
209                 SqlDataReader dr = myCommand.ExecuteReader();
210 
211                 while (dr.Read())
212                     _CT_AppendSetInfo.CT_AppendInfo.Add(Populate(dr));
213 
214                 dr.NextResult();
215 
216                 while (dr.Read())
217                     _CT_AppendSetInfo.TotalRecords = Convert.ToInt32(dr["TotalRecords"]);
218 
219                 dr.Close();
220             }
221             catch (Exception ex)
222             {
223                 WriteDataErrLog.WriteDataErrDetail(myCommand, ex.ToString());
224                 
225             }
226 
227             myConnection.Close();
228 
229             return _CT_AppendSetInfo;
230         }
231 
232 
233       
234         private CT_AppendInfo Populate(SqlDataReader dr)
235         {
236             CT_AppendInfo _CT_AppendInfo = new CT_AppendInfo();
237 
238             _CT_AppendInfo.VC_A_SNNO = Convert.ToString(dr["VC_A_SNNO"]);
239             _CT_AppendInfo.VC_A_AppendType = Convert.ToString(dr["VC_A_AppendType"]);
240             _CT_AppendInfo.VC_A_CardNO = Convert.ToString(dr["VC_A_CardNO"]);
241             _CT_AppendInfo.I_A_CardType = Convert.ToInt32(dr["I_A_CardType"]);
242             _CT_AppendInfo.I_A_CardTypeName = Filter.CardTypeToStr(_CT_AppendInfo.I_A_CardType);
243             _CT_AppendInfo.I_A_PointToOil = Convert.ToInt32(dr["I_A_PointToOil"]);
244             _CT_AppendInfo.VC_TicketType = Convert.ToString(dr["VC_TicketType"]);
245             _CT_AppendInfo.VC_TicketNO = Convert.ToString(dr["VC_TicketNO"]);
246             _CT_AppendInfo.DE_A_BAmount = Convert.ToDecimal(dr["DE_A_BAmount"]);
247             _CT_AppendInfo.DE_A_AppendAmount = Convert.ToDecimal(dr["DE_A_AppendAmount"]);
248             _CT_AppendInfo.DE_A_AAmount = Convert.ToDecimal(dr["DE_A_AAmount"]);
249             _CT_AppendInfo.D_A_AppendDateTime = Convert.ToDateTime(dr["D_A_AppendDateTime"]);
250             _CT_AppendInfo.VC_A_Remark = Convert.ToString(dr["VC_A_Remark"]);
251             _CT_AppendInfo.VC_A_OperatorNO = Convert.ToString(dr["VC_A_OperatorNO"]);
252 
253             return _CT_AppendInfo;
254         }
255     }
256 }
 1 -----------ICT_Append_IDAL.cs---------------------------------------------------------------
 2 // =================================================================== 
 3 // Name: The Interface of CT_Append
 4 // Author: 小华
 5 // DateTime: 2011-07-08
 6 // Description: ICT_Append.cs
 7 // =================================================================== 
 8 using System;
 9 using System.Collections.Generic;
10 using GPOS.Model;
11 
12 namespace GPOS.IDAL
13 {
14     public interface ICT_Append
15     {
16         int Create(CT_AppendInfo _CT_AppendInfo);
17         int Remove(string vC_A_SNNO);
18         CT_AppendInfo GetById(string vC_A_SNNO);
19         PageSetInfo Get(int TotalRecords, int PageIndex);
20 
21         PageSetInfo Search(string VC_A_SNNO, string VC_OC_UserName, string VC_OC_Company, string VC_A_CardNO, int CardType,
22                            string VC_A_AppendType, string VC_TicketType, string VC_TicketNO, string StartDate,
23                            string EndDate, int TotalRecords, int PageIndex);
24     }
25 }
  1 ------CT_AppendInfo.cs--------------------------------------------------------------------
  2 // =================================================================== 
  3 // Name: The Model of CT_Append
  4 // Author: 小华
  5 // DateTime: 2011-07-08
  6 // Description: CT_AppendInfo.cs
  7 // =================================================================== 
  8 
  9 using System;
 10 using System.Collections.Generic;
 11 using System.Linq;
 12 using System.Text;
 13 
 14 namespace GPOS.Model
 15 {
 16     [Serializable]
 17     public class CT_AppendInfo
 18     {
 19         #region Variable definitions
 20         private int _recordNO;
 21         private string _vC_A_SNNO;
 22         private string _vC_A_AppendType = String.Empty;
 23         private string _vC_A_CardNO = String.Empty;
 24         private int _i_A_CardType;
 25         private string _I_A_CardTypeName;
 26         private int _i_A_PointToOil;
 27         private string _vC_TicketType = String.Empty;
 28         private string _vC_TicketNO = String.Empty;
 29         private decimal _dE_A_BAmount;
 30         private decimal _dE_A_AppendAmount;
 31         private decimal _dE_A_AAmount;
 32         private DateTime _d_A_AppendDateTime;
 33         private string _vC_A_Remark = String.Empty;
 34         private string _vC_A_OperatorNO = String.Empty;
 35         #endregion
 36 
 37         #region Public Properties
 38         ///<summary>
 39         ///记录编号
 40         ///</summary>
 41         public int RecordNO
 42         {
 43             get { return _recordNO; }
 44             set { _recordNO = value; }
 45         }
 46 
 47         ///<summary>
 48         ///充值交易序号
 49         ///</summary>
 50         public string VC_A_SNNO
 51         {
 52             get { return _vC_A_SNNO; }
 53             set { _vC_A_SNNO = value; }
 54         }
 55 
 56         ///<summary>
 57         ///充值类型
 58         ///</summary>
 59         public string VC_A_AppendType
 60         {
 61             get { return _vC_A_AppendType; }
 62             set { _vC_A_AppendType = value; }
 63         }
 64 
 65         ///<summary>
 66         ///充值卡号
 67         ///</summary>
 68         public string VC_A_CardNO
 69         {
 70             get { return _vC_A_CardNO; }
 71             set { _vC_A_CardNO = value; }
 72         }
 73 
 74         ///<summary>
 75         ///卡片类型
 76         ///</summary>
 77         public int I_A_CardType
 78         {
 79             get { return _i_A_CardType; }
 80             set { _i_A_CardType = value; }
 81         }
 82 
 83         ///<summary>
 84         ///卡片类型名称
 85         ///</summary>
 86         public string I_A_CardTypeName
 87         {
 88             get { return _I_A_CardTypeName; }
 89             set { _I_A_CardTypeName = value; }
 90         }
 91 
 92         ///<summary>
 93         ///积分/优惠兑换数量
 94         ///</summary>
 95         public int I_A_PointToOil
 96         {
 97             get { return _i_A_PointToOil; }
 98             set { _i_A_PointToOil = value; }
 99         }
100 
101         ///<summary>
102         ///票据类型
103         ///</summary>
104         public string VC_TicketType
105         {
106             get { return _vC_TicketType; }
107             set { _vC_TicketType = value; }
108         }
109 
110         ///<summary>
111         ///票据编号
112         ///</summary>
113         public string VC_TicketNO
114         {
115             get { return _vC_TicketNO; }
116             set { _vC_TicketNO = value; }
117         }
118 
119         ///<summary>
120         ///充值前余额
121         ///</summary>
122         public decimal DE_A_BAmount
123         {
124             get { return _dE_A_BAmount; }
125             set { _dE_A_BAmount = value; }
126         }
127 
128         ///<summary>
129         ///充值金额
130         ///</summary>
131         public decimal DE_A_AppendAmount
132         {
133             get { return _dE_A_AppendAmount; }
134             set { _dE_A_AppendAmount = value; }
135         }
136 
137         ///<summary>
138         ///充值后余额
139         ///</summary>
140         public decimal DE_A_AAmount
141         {
142             get { return _dE_A_AAmount; }
143             set { _dE_A_AAmount = value; }
144         }
145 
146         ///<summary>
147         ///充值时间
148         ///</summary>
149         public DateTime D_A_AppendDateTime
150         {
151             get { return _d_A_AppendDateTime; }
152             set { _d_A_AppendDateTime = value; }
153         }
154 
155         ///<summary>
156         ///备注
157         ///</summary>
158         public string VC_A_Remark
159         {
160             get { return _vC_A_Remark; }
161             set { _vC_A_Remark = value; }
162         }
163 
164         ///<summary>
165         ///操作员物理卡号
166         ///</summary>
167         public string VC_A_OperatorNO
168         {
169             get { return _vC_A_OperatorNO; }
170             set { _vC_A_OperatorNO = value; }
171         }
172         #endregion
173 
174         #region Constructor function
175 
176         public CT_AppendInfo()
177         {
178         }
179 
180         public CT_AppendInfo
181         (
182             int recordNO,
183             string vC_A_SNNO,
184             string vC_A_AppendType,
185             string vC_A_CardNO,
186             int i_A_CardType,
187             int i_A_PointToOil,
188             string vC_TicketType,
189             string vC_TicketNO,
190             decimal dE_A_BAmount,
191             decimal dE_A_AppendAmount,
192             decimal dE_A_AAmount,
193             DateTime d_A_AppendDateTime,
194             string vC_A_Remark,
195             string vC_A_OperatorNO
196         )
197         {
198             _recordNO = recordNO;
199             _vC_A_SNNO = vC_A_SNNO;
200             _vC_A_AppendType = vC_A_AppendType;
201             _vC_A_CardNO = vC_A_CardNO;
202             _i_A_CardType = i_A_CardType;
203             _i_A_PointToOil = i_A_PointToOil;
204             _vC_TicketType = vC_TicketType;
205             _vC_TicketNO = vC_TicketNO;
206             _dE_A_BAmount = dE_A_BAmount;
207             _dE_A_AppendAmount = dE_A_AppendAmount;
208             _dE_A_AAmount = dE_A_AAmount;
209             _d_A_AppendDateTime = d_A_AppendDateTime;
210             _vC_A_Remark = vC_A_Remark;
211             _vC_A_OperatorNO = vC_A_OperatorNO;
212 
213         }
214         #endregion
215 
216     }
217 }

就这麽多了
需要数据库文件的可以Q我:1815357042

问题补充:

我使用的是codesmith5.2

桦仔的主页 桦仔 | 初学一级 | 园豆:62
提问于:2012-08-15 23:17
< >
分享
最佳答案
0

如果要写132个模板,那你还用codesmith做什么,手写算啦

BLL  IDAL  DAL  MODEL

根据各个项目的共性一个项目写一个模板就OK啦,实际上你要做的只是遍历数据库的表结构,然后根据表结构自动生成相关的类而已。

收获园豆:50
I,Robot | 大侠五级 |园豆:9563 | 2012-08-16 13:46

我也知道遍历数据库里的表,每层都是bll  idal   dal  model ,但是就是不知道怎麽写,所以想请教大家

桦仔 | 园豆:62 (初学一级) | 2012-08-16 14:25

@桦仔: 

<%@ Property Name="SourceTable" Type="SchemaExplorer.TableSchema" Category="Context" Description="Table that the object is based on." %>

在你的模板里加入这么一行,你就可以在模板里访问数据表的结构了,你可以看看SchemaExplorer.TableSchema里都有些什么属性。

I,Robot | 园豆:9563 (大侠五级) | 2012-08-16 14:37

@狼Robot: 

在model模板文件里面已经加了这一句

<%@ Property Name="SourceTable" Type="SchemaExplorer.TableSchema" Optional="True" Category="db" Description="表映射文件" %>

请问狼robot大侠能辅导一下我吗,小弟不胜感激,小弟QQ:1815357042

桦仔 | 园豆:62 (初学一级) | 2012-09-06 19:01

@桦仔: 

加了这句代码后,你后面的代码中就可以用

<%%>这样的代码块来写C#代码了。

比如:

<%
foreach(ColumnSchema col in SourceTable.Columns){
    
}
%>

这样就可以遍历表的所有字段了,具体的内容你可以看一下相关类的属性。

I,Robot | 园豆:9563 (大侠五级) | 2012-09-07 00:07

@狼Robot: 

还是想大侠详细一点

桦仔 | 园豆:62 (初学一级) | 2012-09-15 23:06

@桦仔: 

其实你只需要BLL  IDAL  DAL  MODEL各一个模板,找出各个类中的规律,通过遍历表结构生成对应的类就可以了。

比如MODEL类,实际上就是类似下面的代码生成的:

public class <%=SourceTable.Name%>{

<%
foreach(ColumnSchema col in SourceTable.Columns){%>
public <%=col.SystemType%> <%=col.Name%>{get;set;}
<%}
%>

}

I,Robot | 园豆:9563 (大侠五级) | 2012-09-16 00:16
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册