protected void Button1_Click(object sender, EventArgs e)
{
Keel.DBHelper <Table_1> dbt = new Keel.DBHelper <Table_1>();
Table_1 t = dbt.Distill(this.ctl_Table_1_Keel1);
dbt.Fill(this.ctl_Table_1_Keel2, t);
}
public SQL2KDemo.Model.tb_codfiles coop_tb_codfiles_GetOne(string @filemd5)
{
Keel.DBHelper <SQL2KDemo.Model.tb_codfiles> dbi = new Keel.DBHelper <SQL2KDemo.Model.tb_codfiles>();
string[] names = new string[] {
"@filemd5"
};
object[] values = new object[] {
@filemd5
};
return(dbi.ExcStoredProcedure("coop_tb_codfiles_GetOne", Keel.SPExcMethod.Model, names, values));
}
public int coop_tb_codfiles_Insert(string @filemd5, string @filepath)
{
Keel.DBHelper <int> dbi = new Keel.DBHelper <int>();
string[] names = new string[] {
"@filemd5",
"@filepath"
};
object[] values = new object[] {
@filemd5,
@filepath
};
return(dbi.ExcStoredProcedure("coop_tb_codfiles_Insert", Keel.SPExcMethod.ExecuteScalar, names, values));
}
public static void SP_Codsoftitem_Insert(string CodFileMd5, string FullName,
string SoftName,
string Version,
int Size,
DateTime Created,
int Score_Good,
int Score_Bad,
int Money,
DateTime UploadDateTime,
string PhoneTypes,
string PhoneOS)
{
Keel.DBHelper <int> dbi = new Keel.DBHelper <int>();
string[] names = new string[] { "CodFileMd5", "FullName", "SoftName", "Version", "Size", "Created", "Score_Good", "Score_Bad", "Money", "UploadDateTime", "PhoneTypes", "PhoneOS" };
object [] objs = new object[] { CodFileMd5, FullName, SoftName, Version, Size, Created, Score_Good, Score_Bad, Money, UploadDateTime, PhoneTypes, PhoneOS };
int i = dbi.ExcStoredProcedure("SP_Codsoftitem_Insert", Keel.SPExcMethod.ExecuteNonQuery, names, objs);
}
static void Main()
{
Keel.DBHelper <tb_user> t = new Keel.DBHelper <tb_user>();
t.TransactionBegin();
tb_user tx = new tb_user();
tx.username = "******";
t.Insert(tx);
t.TransactionCommit();
t.TransactionBegin();
tx.email = "sadfasdf";
t.Update(tx);
t.TransactionCommit();
tx.password = "******";
t.Update(tx);
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new Form1());
}
public int test1()
{
Keel.DBHelper <int> dbi = new Keel.DBHelper <int>();
return(dbi.ExcStoredProcedure("test1", Keel.SPExcMethod.ExecuteNonQuery));
}
public System.Data.DataSet coop_tb_codsoftitem_GetAll(out List <System.Data.DataSet> _ListOut_keel)
{
Keel.DBHelper <System.Data.DataSet> dbi = new Keel.DBHelper <System.Data.DataSet>();
return(dbi.ExcStoredProcedure("coop_tb_codsoftitem_GetAll", Keel.SPExcMethod.Fill, out _ListOut_keel));
}
public List <SQL2KDemo.Model.tb_codfiles> coop_tb_codfiles_GetAll()
{
Keel.DBHelper <List <SQL2KDemo.Model.tb_codfiles> > dbi = new Keel.DBHelper <List <SQL2KDemo.Model.tb_codfiles> >();
return(dbi.ExcStoredProcedure("coop_tb_codfiles_GetAll", Keel.SPExcMethod.List));
}
