C# (CSharp) DataAccessLayer.DataAccessComponents.DataAccessComponent示例

示例#1

        public static int GetMaxForQuickContacts()
        {
            DataAccessLayer.DataAccessComponents.DataAccessComponent dac = new DataAccessLayer.DataAccessComponents.DataAccessComponent();
            IDataReader reader = dac.SelectStatement("Select Max(QuickContactId) From QuickContact");
            int         result = 0;

            while (reader.Read())
            {
                result = reader.GetInt32(0);
            }
            return(result);
        }

示例#2

        public static string GetUserForQuickContacts(int id)
        {
            DataAccessLayer.DataAccessComponents.DataAccessComponent dac = new DataAccessLayer.DataAccessComponents.DataAccessComponent();
            IDataReader reader = dac.SelectStatement("Select Name From QuickContact Where QuickContactId = " + id);
            string      result = "";

            while (reader.Read())
            {
                result = reader.GetString(0);
            }
            return(result);
        }

示例#3

 public void Delete(string ids, string questionId)
 {
     DataAccessLayer.DataAccessComponents.DataAccessComponent c = new DataAccessLayer.DataAccessComponents.DataAccessComponent();
     c.EXQuery(String.Format("Delete From FormBuilder.FormFieldValue Where FormFieldValueId Not In({0}) and FormFieldId = {1}", ids, questionId));
 }

示例#4

文件： FormFieldColumnLogic.cs 项目： ramyothman/RBM

 public void DeleteByFormFieldId(int FormFieldId)
 {
     DataAccessLayer.DataAccessComponents.DataAccessComponent DAC = new DataAccessLayer.DataAccessComponents.DataAccessComponent("","");
     DAC.EXQuery("Delete From FormBuilder.FormFieldColumn where FormFieldId = " + FormFieldId);
 }

示例#5

文件： FormFieldLogic.cs 项目： ramyothman/Qiyas

 public void Delete(string questionIds, string surveyId)
 {
     DataAccessLayer.DataAccessComponents.DataAccessComponent DAC = new DataAccessLayer.DataAccessComponents.DataAccessComponent();
     DAC.EXQuery(String.Format("Delete From FormBuilder.FormField where FormFieldId Not In({0}) AND FormDocumentId = {1}", questionIds, surveyId));
 }

示例#6

文件： HomePageLogic.cs 项目： ramyothman/RBM

 public void Delete(string ids,int HomePageGroupID)
 {
     DataAccessLayer.DataAccessComponents.DataAccessComponent dac = new DataAccessLayer.DataAccessComponents.DataAccessComponent("","");
     dac.EXQuery("Delete From ContentManagement.HomePage where HomePageGroupID = " + HomePageGroupID + " and HomePageID Not In(" + ids + ")");
 }

示例#7

文件： FormFieldColumnLogic.cs 项目： ramyothman/Qiyas

 public void DeleteByFormFieldId(int FormFieldId)
 {
     DataAccessLayer.DataAccessComponents.DataAccessComponent DAC = new DataAccessLayer.DataAccessComponents.DataAccessComponent();
     DAC.EXQuery("Delete From FormBuilder.FormFieldColumn where FormFieldId = " + FormFieldId);
 }

示例#8

文件： FormFieldLogic.cs 项目： ramyothman/RBM

 public void Delete(string questionIds, string surveyId)
 {
     DataAccessLayer.DataAccessComponents.DataAccessComponent DAC = new DataAccessLayer.DataAccessComponents.DataAccessComponent("","");
     DAC.EXQuery(String.Format("Delete From FormBuilder.FormField where FormFieldId Not In({0}) AND FormDocumentId = {1}", questionIds, surveyId));
 }

示例#9

文件： FormFieldValueLogic.cs 项目： ramyothman/RBM

 public void Delete(string ids, string questionId)
 {
     DataAccessLayer.DataAccessComponents.DataAccessComponent c = new DataAccessLayer.DataAccessComponents.DataAccessComponent("","");
     c.EXQuery(String.Format("Delete From FormBuilder.FormFieldValue Where FormFieldValueId Not In({0}) and FormFieldId = {1}", ids, questionId));
 }

示例#10

文件： Common.cs 项目： ramyothman/RBM

 public static string GetUserForQuickContacts(int id)
 {
     DataAccessLayer.DataAccessComponents.DataAccessComponent dac = new DataAccessLayer.DataAccessComponents.DataAccessComponent("","");
     IDataReader reader = dac.SelectStatement("Select Name From QuickContact Where QuickContactId = " + id);
     string result = "";
     while (reader.Read())
     {
         result = reader.GetString(0);
     }
     return result;
 }

示例#11

文件： Common.cs 项目： ramyothman/RBM

 public static int GetMaxForQuickContacts()
 {
     DataAccessLayer.DataAccessComponents.DataAccessComponent dac = new DataAccessLayer.DataAccessComponents.DataAccessComponent("","");
     IDataReader reader = dac.SelectStatement("Select Max(QuickContactId) From QuickContact");
     int result = 0;
     while (reader.Read())
     {
         result = reader.GetInt32(0);
     }
     return result;
 }