public CommandResult UserRegister(LoginUser user) { var parameters = new[] { new SqlParameter("@username", user.UserName), new SqlParameter("@psw", DESEncrypt.Encrypt(user.Password)), new SqlParameter("@cname", user.CName), new SqlParameter("@caddr", user.CAddr), new SqlParameter("@industorytype", user.IndustoryType), new SqlParameter("@csellphone", user.SellPhone), new SqlParameter("@cLicense", "") // new SqlParameter("@cLicense",astatic.GenFile(user.CName, DateTime.Now.AddMonths(1).ToShortDateString())) }; CommandResult res = new CommandResult(); res.IntResult = 0; DataSet ds = null; try { ds = DataProvider.ExecuteDataSet("usp_UserRegister", parameters); DataRow dr = ds.Tables[0].Rows[0]; res.IntResult = Convert.ToInt32(dr[0]); res.Message = dr[1].ToString(); } finally { ds.Dispose(); } return(res); }
public NavigatorMeta GetNavigator(int appId) { var nm = new NavigatorMeta(); string sql = string.Format("exec [usp_GetNavigateMeta] {0}, {1}", appId, Account.User.UserID); DataSet ds = DataProvider.ExecuteDataSet(sql); nm.Nodes.AddRange(DataProvider.LoadData <EAP_Navigator_Node>(ds.Tables[0])); nm.Asso.AddRange(DataProvider.LoadData <EAP_Navigator_Asso>(ds.Tables[1])); return(nm); }