protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { List <Answer> AnswerList = (List <Answer>)Session["AnswerList"]; if (AnswerList != null) { DbLogic dbAccess = new DbLogic(); for (int i = 0; i < AnswerList.Count; i++) { dbAccess.InsertAnswer(AnswerList[i]); } dbAccess.AddRespondent((int)Session["rid"]); } gridAnswer.DataSource = AnswerList; gridAnswer.DataBind(); ListItem item1 = new ListItem(); item1.Value = "1"; item1.Text = "Yes Please!"; ListItem item2 = new ListItem(); item2.Value = "2"; item2.Text = "No, Thank you!"; rbList.Items.Add(item1); rbList.Items.Add(item2); } }
/// <summary> /// 检查用户的网卡Mac地址 /// </summary> /// <param name="macAddress">Mac地址</param> /// <returns>是否符合限制</returns> private bool CheckMacAddress(string macAddress, string userId) { bool returnValue = false; List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BaseParameterEntity.FieldParameterId, userId)); parameters.Add(new KeyValuePair <string, object>(BaseParameterEntity.FieldCategoryId, "MacAddress")); parameters.Add(new KeyValuePair <string, object>(BaseParameterEntity.FieldEnabled, 1)); DataTable dt = DbLogic.GetDataTable(this.DbHelper, BaseParameterEntity.TableName, parameters); if (dt.Rows.Count > 0) { string parameterCode = string.Empty; string parameterCotent = string.Empty; for (int i = 0; i < dt.Rows.Count; i++) { parameterCode = dt.Rows[i][BaseParameterEntity.FieldParameterCode].ToString(); parameterCotent = dt.Rows[i][BaseParameterEntity.FieldParameterContent].ToString(); returnValue = (macAddress.ToLower()).Equals(parameterCotent.ToLower());//简单格式化一下 if (returnValue) { break; } } } return(returnValue); }
public ActionResult ShowCategories() { BlogContext blogContext = DbLogic.GetDB(); ViewBag.Categories = DbLogic.GetCategories(blogContext); return(View()); }
protected void Button1_Click(object sender, EventArgs e) { SqlConnection con = null; try { con = DbLogic.GetConnection(); con.Open(); String query = "insert into reg values ('" + txtname.Text + "','" + txtmail.Text + "','" + txtmob.Text + "','" + txtadd.Text + "','" + txtpass.Text + "','" + prf.SelectedItem.Text + "')"; SqlCommand com = new SqlCommand(query, con); int result = com.ExecuteNonQuery(); if (result == 1) { Lbl.Text = "Record is Inserted successfully"; Response.Redirect("Cust_LogIn.aspx"); } } catch (Exception err) { Lbl.Text = err.Message.ToString(); txtname.Text = ""; txtmail.Text = ""; txtmob.Text = ""; txtadd.Text = ""; } finally { if (con != null) { con.Close(); } } }
/// <summary> /// /// </summary> /// <param name="userInfo"></param> /// <param name="resourceCategory"></param> /// <param name="targetId"></param> /// <param name="targetResourceCategory"></param> /// <param name="permissionItemCode"></param> /// <returns></returns> public string[] GetPermissionScopeResourceIds(BaseUserInfo userInfo, string resourceCategory, string targetId, string targetResourceCategory, string permissionItemCode) { // 写入调试信息 #if (DEBUG) int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod()); #endif // 加强安全验证防止未授权匿名调用 #if (!DEBUG) LogOnService.UserIsLogOn(userInfo); #endif string[] returnValue = null; using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType)) { try { dbHelper.Open(UserCenterDbConnection); string tableName = BasePermissionItemEntity.TableName; if (!string.IsNullOrEmpty(BaseSystemInfo.SystemCode)) { tableName = BaseSystemInfo.SystemCode + "PermissionItem"; } BasePermissionItemManager permissionItemManager = new BasePermissionItemManager(dbHelper, userInfo, tableName); string permissionItemId = permissionItemManager.GetId(new KeyValuePair <string, object>(BasePermissionItemEntity.FieldCode, permissionItemCode)); List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BasePermissionScopeEntity.FieldTargetId, targetId)); parameters.Add(new KeyValuePair <string, object>(BasePermissionScopeEntity.FieldResourceCategory, resourceCategory)); parameters.Add(new KeyValuePair <string, object>(BasePermissionScopeEntity.FieldPermissionItemId, permissionItemId)); parameters.Add(new KeyValuePair <string, object>(BasePermissionScopeEntity.FieldTargetCategory, targetResourceCategory)); parameters.Add(new KeyValuePair <string, object>(BasePermissionScopeEntity.FieldEnabled, 1)); parameters.Add(new KeyValuePair <string, object>(BasePermissionScopeEntity.FieldDeletionStateCode, 0)); tableName = BasePermissionScopeEntity.TableName; if (!string.IsNullOrEmpty(BaseSystemInfo.SystemCode)) { tableName = BaseSystemInfo.SystemCode + "PermissionScope"; } returnValue = DbLogic.GetProperties(dbHelper, tableName, parameters, 0, BasePermissionScopeEntity.FieldResourceId); BaseLogManager.Instance.Add(dbHelper, userInfo, this.serviceName, MethodBase.GetCurrentMethod()); } catch (Exception ex) { BaseExceptionManager.LogException(dbHelper, userInfo, ex); throw ex; } finally { dbHelper.Close(); } } // 写入调试信息 #if (DEBUG) BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart); #endif return(returnValue); }
public ActionResult Index(string articleCat, string searchString, DateTime?fromDate, DateTime?forDate) { BlogContext db = DbLogic.GetDB(); ViewBag.Categories = DbLogic.GetCategories(db); ViewBag.Articles = StartPageLogic.Search(articleCat, searchString, fromDate, forDate); return(View()); }
public ActionResult AddArticle() { AddArticleViewModel a = new AddArticleViewModel(); BlogContext blogContext = DbLogic.GetDB(); a.CategoryList = DbLogic.GetCategories(blogContext); a.TagsList = DbLogic.GetTags(blogContext).ToList <Tag>(); return(View(a)); }
public ActionResult DeleteArticle(int?id) { Article article = DbLogic.GetArticle(id); if (article == null) { return(Redirect("MyArticles")); } return(View(article)); }
static void Main(string[] args) { var form = new DbForm(); var state = new State(); var db = new DbLogic(); // stuff here var sel = form.Selection; db.Create(state, sel); }
public ActionResult ShowFull(int id) { Article article = DbLogic.GetArticle(id); if (article == null) { return(HttpNotFound()); } ViewBag.Article = article; return(View()); }
public ActionResult EditArticle(int?id) { if (id == null) { return(HttpNotFound()); } Article article = DbLogic.GetArticle(id); if (article != null) { return(View(article)); } return(HttpNotFound()); }
public ActionResult EditCategory(int?id) { if (id == null) { return(HttpNotFound()); } Category category = DbLogic.GetCategory(id); if (category != null) { return(View(category)); } return(HttpNotFound()); }
/// <summary> /// 删除 /// </summary> /// <param name="id">主键</param> /// <returns>影响行数</returns> public int Delete(string id) { int returnValue = 0; // 删除角色权限结构定义 // returnValue = DbLogic.Delete(DbHelper, BaseRoleModuleOperationTable.TableName, BaseRoleModuleOperationTable.FieldRoleId, id); // 删除员工角色表结构定义部分 List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BaseUserRoleEntity.FieldRoleId, id)); returnValue += DbLogic.Delete(DbHelper, BaseUserRoleEntity.TableName, parameters); // 删除角色的表结构定义部分 parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BaseRoleEntity.FieldId, id)); returnValue += DbLogic.Delete(DbHelper, BaseRoleEntity.TableName, parameters); return(returnValue); }
/// <summary> /// 检查用户IP地址 /// </summary> /// <param name="ipAddress">IP地址</param> /// <returns>是否符合限制</returns> private bool CheckIPAddress(string ipAddress, string userId) { bool returnValue = false; List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BaseParameterEntity.FieldParameterId, userId)); parameters.Add(new KeyValuePair <string, object>(BaseParameterEntity.FieldCategoryId, "IPAddress")); parameters.Add(new KeyValuePair <string, object>(BaseParameterEntity.FieldEnabled, 1)); DataTable dt = DbLogic.GetDataTable(this.DbHelper, BaseParameterEntity.TableName, parameters); if (dt.Rows.Count > 0) { string parameterCode = string.Empty; string parameterCotent = string.Empty; for (int i = 0; i < dt.Rows.Count; i++) { parameterCode = dt.Rows[i][BaseParameterEntity.FieldParameterCode].ToString(); parameterCotent = dt.Rows[i][BaseParameterEntity.FieldParameterContent].ToString(); switch (parameterCode) { // 匹配单个IP case "Single": returnValue = CheckSingleIPAddress(ipAddress, parameterCotent); break; // 匹配ip地址段 case "Range": returnValue = CheckIPAddressWithRange(ipAddress, parameterCotent); break; // 匹配带掩码的地址段 case "Mask": returnValue = CheckIPAddressWithMask(ipAddress, parameterCotent); break; } if (returnValue) { break; } } } return(returnValue); }
/// <summary> /// 用户添加之前执行的方法 /// </summary> /// <param name="userEntity">用户实体</param> /// <param name="statusCode">状态码</param> public void BeforeAdd(BaseUserEntity userEntity, out string statusCode) { // 检测成功,可以添加用户 statusCode = StatusCode.OK.ToString(); if (this.Exists(new KeyValuePair <string, object>(BaseUserEntity.FieldUserName, userEntity.UserName) , new KeyValuePair <string, object>(BaseUserEntity.FieldDeletionStateCode, 0))) { // 用户名已重复 statusCode = StatusCode.ErrorUserExist.ToString(); } else { // 检查编号是否重复 if (!string.IsNullOrEmpty(userEntity.Code) && this.Exists(new KeyValuePair <string, object>(BaseUserEntity.FieldCode, userEntity.Code) , new KeyValuePair <string, object>(BaseUserEntity.FieldDeletionStateCode, 0))) { // 编号已重复 statusCode = StatusCode.ErrorNameExist.ToString(); } if (userEntity.IsStaff == 1) { List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BaseStaffEntity.FieldUserName, userEntity.UserName)); parameters.Add(new KeyValuePair <string, object>(BaseStaffEntity.FieldDeletionStateCode, 0)); if (DbLogic.Exists(DbHelper, BaseStaffEntity.TableName, parameters)) { // 编号已重复 statusCode = StatusCode.ErrorNameExist.ToString(); } if (!string.IsNullOrEmpty(userEntity.Code)) { parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BaseStaffEntity.FieldCode, userEntity.Code)); parameters.Add(new KeyValuePair <string, object>(BaseStaffEntity.FieldDeletionStateCode, 0)); if (DbLogic.Exists(DbHelper, BaseStaffEntity.TableName, parameters)) { // 编号已重复 statusCode = StatusCode.ErrorCodeExist.ToString(); } } } } }
/// <summary> /// 判断用户是否有有相应的权限 /// </summary> /// <param name="userId">用户主键</param> /// <param name="permissionItemCode">权限编号</param> /// <returns>有权限</returns> public bool CheckPermission(string userId, string permissionItemCode) { BasePermissionItemManager permissionItemManager = new BasePermissionItemManager(DbHelper); string permissionItemId = permissionItemManager.GetIdByCode(permissionItemCode); // 没有找到相应的权限 if (String.IsNullOrEmpty(permissionItemId)) { return(false); } List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BasePermissionEntity.FieldResourceCategory, BaseUserEntity.TableName)); parameters.Add(new KeyValuePair <string, object>(BasePermissionEntity.FieldResourceId, userId)); parameters.Add(new KeyValuePair <string, object>(BasePermissionEntity.FieldEnabled, "1")); return(DbLogic.Exists(DbHelper, this.CurrentTableName, parameters)); }
////////////////////////////////////////////////////////////////////////////////////////////////////// /// 资源权限设定关系相关 ////////////////////////////////////////////////////////////////////////////////////////////////////// #region public string[] GetResourcePermissionItemIds(BaseUserInfo userInfo, string resourceCategory, string resourceId) /// <summary> /// 获取资源权限主键数组 /// </summary> /// <param name="userInfo">用户</param> /// <param name="resourceCategory">资源分类</param> /// <returns>主键数组</returns> public string[] GetResourcePermissionItemIds(BaseUserInfo userInfo, string resourceCategory, string resourceId) { // 写入调试信息 #if (DEBUG) int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod()); #endif // 加强安全验证防止未授权匿名调用 #if (!DEBUG) LogOnService.UserIsLogOn(userInfo); #endif string[] returnValue = null; using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType)) { try { dbHelper.Open(UserCenterDbConnection); List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BasePermissionEntity.FieldResourceCategory, resourceCategory)); parameters.Add(new KeyValuePair <string, object>(BasePermissionEntity.FieldResourceId, resourceId)); DataTable dataTable = DbLogic.GetDataTable(dbHelper, BasePermissionEntity.TableName, parameters); returnValue = BaseBusinessLogic.FieldToArray(dataTable, BasePermissionEntity.FieldPermissionItemId); BaseLogManager.Instance.Add(dbHelper, userInfo, this.serviceName, AppMessage.PermissionService_GetResourcePermissionItemIds, MethodBase.GetCurrentMethod()); } catch (Exception ex) { BaseExceptionManager.LogException(dbHelper, userInfo, ex); throw ex; } finally { dbHelper.Close(); } } // 写入调试信息 #if (DEBUG) BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart); #endif return(returnValue); }
protected void Button1_Click(object sender, EventArgs e) { SignInfo sj = new SignInfo(); SqlConnection con = null; try { con = DbLogic.GetConnection(); con.Open(); String query = "select * from reg where Mobile = '" + txtm.Text + "' and Password = '******'"; SqlCommand com = new SqlCommand(query, con); SqlDataReader dr = com.ExecuteReader(); if (dr.Read()) { Session["Mobile"] = txtm.Text; Session["Name"] = dr[0].ToString(); Session["Address"] = dr[3].ToString(); Response.Redirect("Customer_After_Login.aspx"); //Lbl.Text = "Successfully Logged"; } else { Label3.Text = "INVALID MOBILE OR PASS"; } } catch (Exception err) { Label3.Text = err.Message; } finally { if (con != null) { con.Close(); } } }
/// <summary> /// 更新 /// </summary> /// <param name="roleEntity">实体</param> /// <param name="statusCode">返回状态码</param> /// <returns>影响行数</returns> public int Update(BaseRoleEntity roleEntity, out string statusCode) { int returnValue = 0; // 检查是否已被其他人修改 if (DbLogic.IsModifed(DbHelper, this.CurrentTableName, roleEntity.Id, roleEntity.ModifiedUserId, roleEntity.ModifiedOn)) { // 数据已经被修改 statusCode = StatusCode.ErrorChanged.ToString(); } else { // 检查名称是否重复 List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BaseRoleEntity.FieldSystemId, roleEntity.SystemId)); parameters.Add(new KeyValuePair <string, object>(BaseRoleEntity.FieldRealName, roleEntity.RealName)); parameters.Add(new KeyValuePair <string, object>(BaseRoleEntity.FieldDeletionStateCode, 0)); if (this.Exists(parameters, roleEntity.Id)) { // 名称已重复 statusCode = StatusCode.ErrorNameExist.ToString(); } else { returnValue = this.UpdateEntity(roleEntity); if (returnValue == 1) { statusCode = StatusCode.OKUpdate.ToString(); } else { statusCode = StatusCode.ErrorDeleted.ToString(); } } } return(returnValue); }
public ActionResult MyArticles() { ViewBag.Articles = DbLogic.GetArticlesOfUser(User.Identity.Name); return(View()); }
public RedirectResult DeleteCategory(int?id) { DbLogic.DeleteCategory(id); return(Redirect("ShowCategories")); }
public void SetUp() { this.testDrills = new List <drill>() { new drill() { drill_id = 1, drill_fuel = 3, drill_score = 11, drill_speed = 20, drill_storage = 10, drill_x = 3, drill_y = 3 }, new drill() { drill_id = 2, drill_fuel = 4, drill_score = 12, drill_speed = 21, drill_storage = 11, drill_x = 4, drill_y = 5 }, new drill() { drill_id = 3, drill_fuel = 5, drill_score = 13, drill_speed = 22, drill_storage = 12, drill_x = 6, drill_y = 6 }, new drill() { drill_id = 4, drill_fuel = 6, drill_score = 14, drill_speed = 23, drill_storage = 13, drill_x = 14, drill_y = 13 }, new drill() { drill_id = 5, drill_fuel = 7, drill_score = 15, drill_speed = 25, drill_storage = 17, drill_x = 15, drill_y = 12 }, }; this.testBricks = new List <brick>() { new brick() { brick_id = 1, brick_type = "gold", brick_x = 10, brick_y = 10 }, new brick() { brick_id = 2, brick_type = "silver", brick_x = 15, brick_y = 22 }, new brick() { brick_id = 3, brick_type = "bronze", brick_x = 24, brick_y = 11 }, new brick() { brick_id = 4, brick_type = "gold", brick_x = 16, brick_y = 24 }, new brick() { brick_id = 5, brick_type = "silver", brick_x = 11, brick_y = 34 }, }; this.testConnections = new List <conn>() { new conn() { conn_id = 1, conn_drill_id = 1, conn_brick_id = 1 }, new conn() { conn_id = 2, conn_drill_id = 2, conn_brick_id = 2 }, new conn() { conn_id = 3, conn_drill_id = 3, conn_brick_id = 3 }, new conn() { conn_id = 4, conn_drill_id = 4, conn_brick_id = 4 }, new conn() { conn_id = 5, conn_drill_id = 5, conn_brick_id = 5 }, }; this.testDrill = new drill() { drill_id = 2, drill_fuel = 3, drill_score = 10, drill_speed = 20, drill_storage = 10, drill_x = 3, drill_y = 3 }; this.testBrick = new brick() { brick_id = 2, brick_type = "gold", brick_x = 5, brick_y = 6 }; this.testConn = new conn() { conn_id = 1, conn_brick_id = 2, conn_drill_id = 2 }; this.drillRepo = new Mock <IDrillRepository>(MockBehavior.Loose); this.drillRepo.Setup(c => c.GetAll()).Returns(this.testDrills.AsQueryable()); this.brickRepo = new Mock <IBrickRepository>(MockBehavior.Loose); this.brickRepo.Setup(c => c.GetAll()).Returns(this.testBricks.AsQueryable()); this.connRepo = new Mock <IConnRepository>(MockBehavior.Loose); this.connRepo.Setup(c => c.GetAll()).Returns(this.testConnections.AsQueryable()); this.gameModel = new GameModel(500, 500); this.dbLogic = new DbLogic(this.gameModel, this.drillRepo.Object, this.brickRepo.Object, this.connRepo.Object); }
public ActionResult DeleteConfirmed(int id) { DbLogic.DeleteArticle(id); return(Redirect("MyArticles")); }