protected void Page_Load(object sender, EventArgs e)
{
string conn = "server=192.168.104.117;uid=wftsa;password=jd7nTF#wM;database=k2Sln";
//object dt = db.ExecScalarInt(" select top 22 * from k2sln.dbo.TB_SNDA_Common_VirtualRole ");
//Response.Write(dt);
DbMap map = new DbMapSqlServer(conn);
// string sql = "select top 1 * from k2sln.dbo.TB_SNDA_Common_VirtualRole where idx=27617";
// IDataReader dr = map.db.GetReader(sql);
// VirtualRole1 role = map.Get<VirtualRole1>(sql);
// Response.Write(role.Proccode);
//insert :
//VirtualRole1 vr = new VirtualRole1()
//{
// Proccode = "njhtext",
// RoleGroupCode = "njhtest",
// RoleGroupName = "njhtest",
// SpecialPersonid = "snda\\niejunhua",
//};
////int rs = map.Insert<VirtualRole1>(vr);
//// Response.Write(rs);
//vr = new VirtualRole1();
//vr = map.Get<VirtualRole1>(sql);
//vr.Proccode = "njhprocvcode";
//int idd = map.Update<VirtualRole1>(vr);
//Response.Write(idd);
SqlServerModeCreate core = new SqlServerModeCreate(conn);
core.CreateAll("", "K2SLN");
}
protected void Page_Load(object sender, EventArgs e)
{
string conn = "server=192.168.104.117;uid=wftsa;password=jd7nTF#wM;database=k2Sln";
//object dt = db.ExecScalarInt(" select top 22 * from k2sln.dbo.TB_SNDA_Common_VirtualRole ");
//Response.Write(dt);
DbMap map = new DbMapSqlServer(conn);
// string sql = "select top 1 * from k2sln.dbo.TB_SNDA_Common_VirtualRole where idx=27617";
// IDataReader dr = map.db.GetReader(sql);
// VirtualRole1 role = map.Get<VirtualRole1>(sql);
// Response.Write(role.Proccode);
//insert :
//VirtualRole1 vr = new VirtualRole1()
//{
// Proccode = "njhtext",
// RoleGroupCode = "njhtest",
// RoleGroupName = "njhtest",
// SpecialPersonid = "snda\\niejunhua",
//};
////int rs = map.Insert<VirtualRole1>(vr);
//// Response.Write(rs);
//vr = new VirtualRole1();
//vr = map.Get<VirtualRole1>(sql);
//vr.Proccode = "njhprocvcode";
//int idd = map.Update<VirtualRole1>(vr);
//Response.Write(idd);
SqlServerModeCreate core = new SqlServerModeCreate(conn);
core.CreateAll("", "K2SLN");
}
