Exemple #1
0
 public static int SP_Codsoftitem_Insert(string CodFileMd5, string FullName, string SoftName, string Version, int Size, System.DateTime Created, int Score_Good, int Score_Bad, int Money, System.DateTime UploadDateTime, string PhoneTypes, string PhoneOS)
 {
     Keel.SPHelper <int, object> dbi = new Keel.SPHelper <int, object>();
     string[] names = new string[] {
         "CodFileMd5",
         "FullName",
         "SoftName",
         "Version",
         "Size",
         "Created",
         "Score_Good",
         "Score_Bad",
         "Money",
         "UploadDateTime",
         "PhoneTypes",
         "PhoneOS"
     };
     object[] values = new object[] {
         CodFileMd5,
         FullName,
         SoftName,
         Version,
         Size,
         Created,
         Score_Good,
         Score_Bad,
         Money,
         UploadDateTime,
         PhoneTypes,
         PhoneOS
     };
     return(dbi.ExcStoredProcedure("SP_Codsoftitem_Insert", Keel.SPExcMethod.ExecuteNonQuery, names, values));
 }
Exemple #2
0
 public static int coop_tb_codfiles_Delete(string filemd5)
 {
     Keel.SPHelper <int, object> dbi = new Keel.SPHelper <int, object>();
     string[] names = new string[] {
         "filemd5"
     };
     object[] values = new object[] {
         filemd5
     };
     return(dbi.ExcStoredProcedure("coop_tb_codfiles_Delete", Keel.SPExcMethod.ExecuteNonQuery, names, values));
 }
Exemple #3
0
 public static int SP_Codfiles_QuickSearch(string searchKey)
 {
     Keel.SPHelper <int, object> dbi = new Keel.SPHelper <int, object>();
     string[] names = new string[] {
         "searchKey"
     };
     object[] values = new object[] {
         searchKey
     };
     return(dbi.ExcStoredProcedure("SP_Codfiles_QuickSearch", Keel.SPExcMethod.ExecuteNonQuery, names, values));
 }
Exemple #4
0
 public static int SP_Codfiles_SelectByPK(string Filemd5)
 {
     Keel.SPHelper <int, object> dbi = new Keel.SPHelper <int, object>();
     string[] names = new string[] {
         "Filemd5"
     };
     object[] values = new object[] {
         Filemd5
     };
     return(dbi.ExcStoredProcedure("SP_Codfiles_SelectByPK", Keel.SPExcMethod.ExecuteNonQuery, names, values));
 }
Exemple #5
0
 public static int SP_Codfiles_Insert(string Filemd5, string Filepath)
 {
     Keel.SPHelper <int, object> dbi = new Keel.SPHelper <int, object>();
     string[] names = new string[] {
         "Filemd5",
         "Filepath"
     };
     object[] values = new object[] {
         Filemd5,
         Filepath
     };
     return(dbi.ExcStoredProcedure("SP_Codfiles_Insert", Keel.SPExcMethod.ExecuteNonQuery, names, values));
 }
Exemple #6
0
 public static int SP_User_Insert(string Username, string Password, string Phonetype, string Email)
 {
     Keel.SPHelper <int, object> dbi = new Keel.SPHelper <int, object>();
     string[] names = new string[] {
         "Username",
         "Password",
         "Phonetype",
         "Email"
     };
     object[] values = new object[] {
         Username,
         Password,
         Phonetype,
         Email
     };
     return(dbi.ExcStoredProcedure("SP_User_Insert", Keel.SPExcMethod.ExecuteNonQuery, names, values));
 }
Exemple #7
0
 public static int coop_tb_user_GetAll()
 {
     Keel.SPHelper <int, object> dbi = new Keel.SPHelper <int, object>();
     return(dbi.ExcStoredProcedure("coop_tb_user_GetAll", Keel.SPExcMethod.ExecuteNonQuery));
 }
Exemple #8
0
 public static int test1()
 {
     Keel.SPHelper <int, object> dbi = new Keel.SPHelper <int, object>();
     return(dbi.ExcStoredProcedure("test1", Keel.SPExcMethod.ExecuteNonQuery));
 }
Exemple #9
0
 public static int SP_Codfiles_SelectAll()
 {
     Keel.SPHelper <int, object> dbi = new Keel.SPHelper <int, object>();
     return(dbi.ExcStoredProcedure("SP_Codfiles_SelectAll", Keel.SPExcMethod.ExecuteNonQuery));
 }