public void InsertSecurity(Common.AdminDatum dm) { SqlParameter[] prms = new SqlParameter[2]; prms[0] = new SqlParameter("@id_admin", dm.Id_admin); prms[1] = new SqlParameter("@security", dm.Security); sh.ExecuteNonQuery("shop_admin_security_insert", prms); }
public DataTable CheckLogin(Common.AdminDatum dm) { SqlParameter[] prms = new SqlParameter[2]; prms[0] = new SqlParameter("@username", dm.UserName); prms[1] = new SqlParameter("@Password", dm.Password); return(sh.ExecuteDataSet("shop_admin_Check_Login", prms)); }
public void Insert(Common.AdminDatum dm) { SqlParameter[] prms = new SqlParameter[3]; prms[0] = new SqlParameter("@name", dm.Name); prms[1] = new SqlParameter("@password", dm.Password); prms[2] = new SqlParameter("@userName", dm.UserName); sh.ExecuteNonQuery("shop_admin_insert", prms); }
public void Update(Common.AdminDatum dm) { SqlParameter[] prms = new SqlParameter[4]; prms[0] = new SqlParameter("@id", dm.Id_admin); prms[1] = new SqlParameter("@name", dm.Name); prms[2] = new SqlParameter("@password", dm.Password); prms[3] = new SqlParameter("@userName", dm.UserName); sh.ExecuteNonQuery("shop_admin_update", prms); }
public DataTable Select_page_One(Common.AdminDatum dm) { SqlParameter[] prms = new SqlParameter[1]; prms[0] = new SqlParameter("@id_admin", dm.Id_admin); return(sh.ExecuteDataSet("shop_admin_select_one", prms)); }
public void DeletSecurity(Common.AdminDatum dm) { SqlParameter[] prms = new SqlParameter[1]; prms[0] = new SqlParameter("@id_admin", dm.Id_admin); sh.ExecuteNonQuery("shop_admin_security_delete", prms); }
public DataTable CheckUserExist(Common.AdminDatum dm) { SqlParameter[] prms = new SqlParameter[1]; prms[0] = new SqlParameter("@username", dm.UserName); return(sh.ExecuteDataSet("shop_admin_user_check", prms)); }
public DataTable Select_page_One(Common.AdminDatum dm) { return(dl.Select_page_One(dm)); }
public void Insert(Common.AdminDatum dm) { dl.Insert(dm); }
public void DeletSecurity(Common.AdminDatum dm) { dl.DeletSecurity(dm); }
public DataTable SelectSecurity(Common.AdminDatum dm) { return(dl.SelectSecurity(dm)); }
public void InsertSecurity(Common.AdminDatum dm) { dl.InsertSecurity(dm); }
public void Delete(Common.AdminDatum dm) { dl.Delete(dm); }
public void Update(Common.AdminDatum dm) { dl.Update(dm); }
public DataTable CheckLogin(Common.AdminDatum dm) { return(dl.CheckLogin(dm)); }
public DataTable CheckUserExist(Common.AdminDatum dm) { return(dl.CheckUserExist(dm)); }