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"));
}
