public M_Card GetEntity(string id)
{
SqlParameter[] parms = { new SqlParameter("@CardId", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(id);
M_Card entity = null;
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_M_Card_Repository_GetEntity, parms)) {
if (rdr.Read())
{
entity = new M_Card();
entity.CardId = SqlTypeConverter.DBNullStringHandler(rdr["HexCode"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.Uid = SqlTypeConverter.DBNullStringHandler(rdr["Uid"]);
entity.Password = SqlTypeConverter.DBNullStringHandler(rdr["PWD"]);
entity.Type = SqlTypeConverter.DBNullCardTypeHandler(rdr["Type"]);
entity.Status = SqlTypeConverter.DBNullCardStatusHandler(rdr["Status"]);
entity.StatusTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["StatusTime"]);
entity.StatusReason = SqlTypeConverter.DBNullStringHandler(rdr["StatusReason"]);
entity.BeginTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["BeginTime"]);
entity.Remarks = SqlTypeConverter.DBNullStringHandler(rdr["Desc"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
}
}
return(entity);
}
/// <summary>
/// 双卡激活
/// </summary>
public bool DoubleActivation(string card1, string card2, int uid)
{
if (card1 == card2)
{
return(false);
} //不能传入同一个卡号
M_Card cardMod1 = SelectNum(card1);
M_Card cardMod2 = SelectNum(card2);
if (cardMod1.CardNum == string.Empty || cardMod2.CardNum == string.Empty)
{
return(false);
} //卡号不存在
if (cardMod1.ActivateState == 1 || cardMod2.ActivateState == 1)
{
return(false);
} //已被使用
if (cardMod1.CircumscribeTime < DateTime.Now || cardMod2.CircumscribeTime < DateTime.Now)
{
return(false);
} //已过期
string set = "StartTime = @time , ActivateState = 1 , ActivateUserID = " + uid;
string where = "CardNum = @card1 OR CardNum = @card2";
List <SqlParameter> sp = new List <SqlParameter>();
sp.Add(new SqlParameter("time", DateTime.Now.ToString()));
sp.Add(new SqlParameter("card1", card1));
sp.Add(new SqlParameter("card2", card2));
return(DBCenter.UpdateSQL(TbName, set, where, sp));
}
public void DardgeVip_Open()
{
B_Card cardBll = new B_Card();
string cardnum = Request.Form["txtVIP"];
string cardpas = Request.Form["txtPas"];
M_Card aa = cardBll.SelectNum(cardnum);
if (aa.CardNum == null)
{
function.WriteErrMsg("没有此卡ID"); return;
}
if (string.IsNullOrEmpty(cardnum) || string.IsNullOrEmpty(cardpas))
{
function.WriteErrMsg("卡号与密码不能为空"); return;
}
if (!cardBll.SelectPas(cardnum, cardpas))
{
function.WriteErrMsg("密码不正确");
}
if (cardBll.GetUpdatePas(cardnum, cardpas, buser.GetLogin().UserID))
{
function.WriteSuccessMsg("验证成功"); return;
}
else
{
function.WriteErrMsg("验证失败"); return;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (DataConverter.CDate(endtime.Text) < DateTime.Now.Date)
{
function.WriteErrMsg("到期时间不能早于当前时间!");
return;
}
if (DataConverter.CDate(createtime_T.Text) >= DataConverter.CDate(endtime.Text))
{
function.WriteErrMsg("到期时间不能晚于发布时间!");
return;
}
int numo = DataConverter.CLng(this.num.Text);
for (int i = 0; i < numo; i++)
{
M_Card caro = new M_Card();
M_UserInfo muser = buser.GetUserByName(this.tx_user.Text.Trim());
caro.PutUserID = muser.UserID;
//caro.CardNum = cardnumo(caro.PutUserID, num);
string len = "asdfghjklmnbvcxzpoiuytrewqASDFGHJKLPOIUYTREWQZXCVBNM";
string n = "1234567890";
string m = "mnbvcxzqwertyuioplkjhgfdsaLPOKMIJNUHBYGVTFCRDXESZWAQ0192837465";
int length = DataConverter.CLng(Len_T.Text.Trim());
if (length < 4)
{
function.WriteErrMsg("卡号长度不能少于4位!");
}
switch (EcodeType.SelectedItem.Value)
{
case "0":
caro.CardNum = DataSecurity.MakeRandomString(n, length);
break;
case "1":
caro.CardNum = "ZL" + DataSecurity.MakeRandomString(len, length - 2);
break;
case "2":
caro.CardNum = "ZL" + DataSecurity.MakeRandomString(m, length - 2);
break;
default:
break;
}
caro.AddTime = DataConverter.CDate(createtime_T.Text);
caro.CircumscribeTime = DataConverter.CDate(endtime.Text);
caro.CardPwd = "ZL" + DataSecurity.MakeRandomString(n, 3) + DataSecurity.MakeRandomString(len, 1) + DataSecurity.MakeRandomString(n, 1) + DataSecurity.MakeRandomString(m, 1);
caro.VIPType = DataConverter.CLng(DropDownList2.SelectedValue.ToString());
caro.CircumscribeTime = DataConverter.CDate(endtime.Text);
caro.CardState = DataConverter.CLng(Request["isopen"]);
caro.ActivateState = 0;
bcard.GetInsert(caro);
System.Threading.Thread.Sleep(50); //停0.05秒
}
function.WriteSuccessMsg("添加成功!", "CardManage.aspx");
}
public bool InsertUpdate(M_Card model)
{
if (model.Card_ID > 0)
{
GetUpdate(model);
}
else
{
GetInsert(model);
}
return(true);
}
public string showuse(string id)
{
int sid = DataConverter.CLng(id);
string str = "";
M_Card tp = bc.GetSelect(sid);
if (tp.CardState == 1)
{
str = "<a href=?menu=stop&id=" + sid + "><i class='fa fa-check'></i>启用</a>";
}
else
{
str = "<a href=?menu=isuse&id=" + sid + "><i class='fa fa-ban'></i>禁用</a>";
}
return(str);
}
public List <M_Card> GetEntities()
{
var entities = new List <M_Card>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_M_Card_Repository_GetEntities, null)) {
while (rdr.Read())
{
var entity = new M_Card();
entity.CardId = SqlTypeConverter.DBNullStringHandler(rdr["HexCode"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.Uid = SqlTypeConverter.DBNullStringHandler(rdr["Uid"]);
entity.Password = SqlTypeConverter.DBNullStringHandler(rdr["PWD"]);
entity.Type = SqlTypeConverter.DBNullCardTypeHandler(rdr["Type"]);
entity.Status = SqlTypeConverter.DBNullCardStatusHandler(rdr["Status"]);
entity.StatusTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["StatusTime"]);
entity.StatusReason = SqlTypeConverter.DBNullStringHandler(rdr["StatusReason"]);
entity.BeginTime = SqlTypeConverter.DBNullDateTimeHandler(rdr["BeginTime"]);
entity.Remarks = SqlTypeConverter.DBNullStringHandler(rdr["Desc"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
entities.Add(entity);
}
}
return(entities);
}
public bool GetUpdate(M_Card model)
{
return(Sql.UpdateByIDs(TbName, PK, model.Card_ID.ToString(), BLLCommon.GetFieldAndPara(model), model.GetParameters()));
}
public bool GetInsert(M_Card model)
{
return(Sql.insertID(TbName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)) > 0);
}
