public BlackUser getUserById(string userId)
{
BlackUser blackUser = null;
if (String.IsNullOrWhiteSpace(userId))
{
return(blackUser);
}
using (var context = WDbContext()) {
string strSql = @"select BlackID,Card_Id,Card_Name,U_Tel,User_ID,User_Name,STATE,AddDate,MEMO,FLAG,CreateDate
from Base_User_BlackList where BlackID='{0}'";
strSql = string.Format(strSql, userId);
blackUser = context.Sql(strSql)
.QuerySingle <BlackUser>();
}
return(blackUser);
}
public int editBlackUser(BlackUser user)
{
var retData = 0;
if (user == null || string.IsNullOrWhiteSpace(user.Card_Id) || string.IsNullOrWhiteSpace(user.Card_Name))
{
return(retData);
}
using (var context = WDbContext())
{
return(context.Update("Base_User_BlackList")
.Column("Card_Id", user.Card_Id)
.Column("Card_Name", user.Card_Name)
.Column("U_Tel", user.U_Tel)
.Column("User_ID", user.User_ID)
.Column("User_Name", user.User_Name)
.Column("STATE", user.STATE)
.Column("MEMO", user.MEMO)
.Column("FLAG", user.FLAG)
.Where("BlackID", user.BlackID)
.Execute());
}
}
public int addBlackUser(BlackUser user)
{
var retData = 0;
if (user == null || string.IsNullOrWhiteSpace(user.Card_Id) || string.IsNullOrWhiteSpace(user.Card_Name))
{
return(retData);
}
using (var context = WDbContext()) {
return(context.Insert("Base_User_BlackList")
.Column("BlackID", Guid.NewGuid())
.Column("Card_Id", user.Card_Id)
.Column("Card_Name", user.Card_Name)
.Column("U_Tel", user.U_Tel)
.Column("User_ID", user.User_ID)
.Column("User_Name", user.User_Name)
.Column("STATE", user.STATE)
.Column("AddDate", user.AddDate)
.Column("MEMO", user.MEMO)
.Column("FLAG", user.FLAG)
.Column("CreateDate", user.CreateDate)
.Execute());
}
}
protected void Save_Click(object sender, EventArgs e)
{
this.lab_msg.InnerText = "";
var cardId = this.Card_ID.Value;
var cardName = this.Card_Name.Value;
var tel = this.Card_Tel.Value;
var memo = this.Memo.Value;
var blackUserId = "";
var currUser = RequestSession.GetSessionUser();
if (currUser == null)
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "", "top.location.href='/Login.html';", true);
return;
}
if (!string.IsNullOrWhiteSpace(this.Request["userId"]))
{
blackUserId = this.Request["userId"].ToString();
}
BlackUser bUser = new BlackUser()
{
AddDate = DateTime.Now,
BlackID = blackUserId,
Card_Id = cardId,
Card_Name = cardName,
CreateDate = DateTime.Now,
FLAG = 0,
MEMO = memo,
STATE = 0,
User_ID = currUser.UserId.ToString(),
User_Name = currUser.UserName.ToString(),
U_Tel = tel
};
if (blackService.checkUserExists(cardId, bUser.BlackID))
{
this.lab_msg.InnerText = "该用户已存在";
return;
}
var execResult = 0;
if (!string.IsNullOrWhiteSpace(bUser.BlackID))
{
execResult = blackService.editBlackUser(bUser);
}
else
{
execResult = blackService.addBlackUser(bUser);
}
if (execResult <= 0)
{
this.lab_msg.InnerText = "保存失败";
return;
}
else
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "", "OpenClose();", true);
return;
}
}
