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