/// <summary> /// Generate Delete Code /// </summary> protected override void concatDelete() { string colName; if (CheckedListBox1.CheckedItems.Contains("Delete()") || CheckedListBox1.CheckedItems.Contains("DeleteList()")) { SbTemp.Append("\r\n#region Delete"); } #region Delete if (CheckedListBox1.CheckedItems.Contains("Delete()")) { //Delete Item SbTemp.Append("\r\n"); SbTemp.Append("\r\n///<summary>"); SbTemp.Append("\r\n///Delete Item(exception when return null)"); SbTemp.Append("\r\n///</summary>"); SbTemp.AppendFormat("\r\n int? Delete({0} model);", PreModel + TableName); } #endregion #region DeleteList if (CheckedListBox1.CheckedItems.Contains("DeleteList()")) { //DeleteList SbTemp.Append("\r\n"); SbTemp.Append("\r\n///<summary>"); SbTemp.Append("\r\n///Delete Items(exception when return null)"); SbTemp.Append("\r\n///</summary>"); SbTemp.AppendFormat("\r\n int? DeleteList(List<{0}> listModel);", PreModel + TableName); } #endregion #region Delete By String Array(Format '1','2','3')[DeletebyKeys] if (CheckedListBox1.CheckedItems.Contains("DeletebyKeys()")) { SbTemp.Append("\r\n"); SbTemp.Append("\r\n///<summary>"); SbTemp.Append("\r\n///Delete By String Array(Format'1','2','3')(exception when return null)"); SbTemp.Append("\r\n///</summary>"); SbTemp.AppendFormat("\r\n int? DeletebyKeys(string keys);", TableName); } #endregion if (CheckedListBox1.CheckedItems.Contains("Delete()") || CheckedListBox1.CheckedItems.Contains("DeleteList()")) { SbTemp.Append("\r\n#endregion"); } SbTemp.Append("\r\n"); }
/// <summary> /// Generate IDAL /// </summary> public override StringBuilder Generate() { concatNamespace(); concatGet(); concatInsert(); concatUpdate(); concatDelete(); SbTemp.Append("\r\n}"); SbTemp.Append("\r\n}"); return(SbTemp); }
/// <summary> /// Generate Update Code /// </summary> protected override void concatUpdate() { if (CheckedListBox1.CheckedItems.Contains("Update()") || CheckedListBox1.CheckedItems.Contains("UpdateList()")) { SbTemp.Append("\r\n#region Update"); } #region Update if (CheckedListBox1.CheckedItems.Contains("Update()")) { //UpdateItem SbTemp.Append("\r\n"); SbTemp.Append("\r\n///<summary>"); SbTemp.Append("\r\n///UpdateItem(exception when return null)"); SbTemp.Append("\r\n///</summary>"); SbTemp.AppendFormat("\r\n int? Update({0} model);", PreModel + TableName); } #endregion #region UpdateList if (CheckedListBox1.CheckedItems.Contains("UpdateList()")) { //UpdateList SbTemp.Append("\r\n"); SbTemp.Append("\r\n///<summary>"); SbTemp.Append("\r\n///UpdateItemList(exception when return null)"); SbTemp.Append("\r\n///</summary>"); SbTemp.AppendFormat("\r\n int? UpdateList(List<{0}> listModel);", PreModel + TableName); } #endregion if (CheckedListBox1.CheckedItems.Contains("Update()") || CheckedListBox1.CheckedItems.Contains("UpdateList()")) { SbTemp.Append("\r\n#endregion"); } SbTemp.Append("\r\n"); }
/// <summary> /// Generate Insert Code /// </summary> protected override void concatInsert() { string colName; if (CheckedListBox1.CheckedItems.Contains("Insert()") || CheckedListBox1.CheckedItems.Contains("InsertList()")) { SbTemp.Append("\r\n#region Insert"); } #region Insert if (CheckedListBox1.CheckedItems.Contains("Insert()")) { //Insert Item SbTemp.Append("\r\n"); SbTemp.Append("\r\n///<summary>"); SbTemp.Append("\r\n///Insert Item(exception when return null)"); SbTemp.Append("\r\n///</summary>"); SbTemp.AppendFormat("\r\n int? Insert({0} model);", PreModel + TableName); } #endregion #region InsertList if (CheckedListBox1.CheckedItems.Contains("InsertList()")) { SbTemp.Append("\r\n"); SbTemp.Append("\r\n///<summary>"); SbTemp.Append("\r\n///InsertList(exception when return null)"); SbTemp.Append("\r\n///</summary>"); SbTemp.AppendFormat("\r\n int? InsertList(List<{0}> listModel);", PreModel + TableName); } #endregion if (CheckedListBox1.CheckedItems.Contains("Insert()") || CheckedListBox1.CheckedItems.Contains("InsertList()")) { SbTemp.Append("\r\n#endregion"); } SbTemp.Append("\r\n"); }
/// <summary> /// Generate NameSpace Code /// </summary> protected override void concatNamespace() { //Cite NameSpace SbTemp.Append("using System;"); SbTemp.Append("\r\n"); SbTemp.Append("using System.Data;"); SbTemp.Append("\r\n"); SbTemp.Append("using System.Collections.Generic;"); SbTemp.Append("\r\n"); SbTemp.Append("\r\n").Append("namespace ").Append(PreNs); SbTemp.Append("\r\n").Append("{"); SbTemp.Append("\r\n").Append("/// <summary>"); SbTemp.Append("\r\n").Append("///").Append("Data Access Interface"); SbTemp.Append("\r\n").Append("/// </summary>"); SbTemp.Append("\r\n").Append("public interface I").Append(TableName); SbTemp.Append("\r\n").Append("{"); }
/// <summary> /// Generate Query Code /// </summary> protected override void concatGet() { if (CheckedListBox1.CheckedItems.Contains("GetList()") || CheckedListBox1.CheckedItems.Contains("GetModel()") || CheckedListBox1.CheckedItems.Contains("GetModelList()")) { SbTemp.Append("\r\n#region Query"); } #region GetList if (CheckedListBox1.CheckedItems.Contains("GetList()")) { //GetList SbTemp.Append("\r\n"); SbTemp.Append("\r\n///<summary>"); SbTemp.Append("\r\n///GetList(exception when return null)"); SbTemp.Append("\r\n///</summary>"); SbTemp.AppendFormat("\r\n DataTable GetList({0} model);", PreModel + TableName); } #endregion #region GetModel if (CheckedListBox1.CheckedItems.Contains("GetModel()")) { //GetModel SbTemp.Append("\r\n"); SbTemp.Append("\r\n///<summary>"); SbTemp.Append("\r\n///GetModel(exception or empty data when return null)"); SbTemp.Append("\r\n///</summary>"); SbTemp.AppendFormat("\r\n {0} GetModel({1} model);", PreModel + TableName, PreModel + TableName); } #endregion #region GetModelList if (CheckedListBox1.CheckedItems.Contains("GetModelList()")) { //GetModelList SbTemp.Append("\r\n"); SbTemp.Append("\r\n///<summary>"); SbTemp.Append("\r\n///GetModelList(exception when return null)"); SbTemp.Append("\r\n///</summary>"); SbTemp.AppendFormat("\r\n List<{0}> GetModelList({1} model);", PreModel + TableName, PreModel + TableName); } #endregion if (CheckedListBox1.CheckedItems.Contains("GetList()") || CheckedListBox1.CheckedItems.Contains("GetModel()") || CheckedListBox1.CheckedItems.Contains("GetModelList()")) { SbTemp.Append("\r\n#endregion"); } SbTemp.Append("\r\n"); }