public bool update1(Model.Card card) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Card set "); strSql.Append("Reason=@Reason,"); strSql.Append("ANumber1=@ANumber1,"); strSql.Append("Status=@Status,"); strSql.Append("CardStatus=@CardStatus"); strSql.Append(" where "); strSql.Append("ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@Reason", SqlDbType.VarChar, 50), new SqlParameter("@Status", SqlDbType.Int), new SqlParameter("@ANumber1", SqlDbType.Int), new SqlParameter("@CardStatus", SqlDbType.Int), new SqlParameter("@ID", SqlDbType.Int) }; parameters[0].Value = card.Reason; parameters[1].Value = card.Status; parameters[2].Value = card.ANumber1; parameters[3].Value = card.CardStatus; parameters[4].Value = card.Id; int rows = DB.DbHelperSQL.ExecuteSql(strSql.ToString(), parameters, DB.DbHelperSQL.maindataConnectionString); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 根据卡片类别调用名称和用户名,为用户创建卡片 /// </summary> /// <param name="callindex">卡片类别调用名称</param> /// <param name="username">用户名</param> /// <param name="token">token</param> /// <returns></returns> public int CreateUserCard(string callindex, string username) { BLL.Card cardBll = new BLL.Card(); BLL.CardCategory cardCategoryBll = new BLL.CardCategory(); BLL.UserCard ucBLL = new BLL.UserCard(); BLL.users usersBll = new BLL.users(); var user = usersBll.GetModel(username); var cardCategory = cardCategoryBll.GetModel(callindex); var card = new Model.Card(); card.CardCategoryId = cardCategory.CardCategoryId; card.Code = Common.Utils.GetCheckCode(7); card.CreateDate = DateTime.Now; card.StartDate = DateTime.Now; card.EndDate = card.StartDate.AddDays(double.Parse(cardCategory.Duration.ToString())); int cardId = cardBll.Add(card); var uc = new Model.UserCard(); uc.CardId = cardId; uc.UserId = user.id; uc.CardCategoryId = cardCategory.CardCategoryId; return(ucBLL.Add(uc)); }
public AddEdit_ViewModel(Model.Card card) : base(new View.AddEdit_View()) { td = new List <string>(); td.Add("КД"); td.Add("ПД"); td.Add("Акт"); ad = new List <Model.Card.File>(); del = new List <Model.Card.File>(); managers = ((App)App.Current).all_data.get_person("worker"); foreach (var item in ((App)App.Current).all_data.get_person("manager")) { managers.Add(item); } top_managers = ((App)App.Current).all_data.get_person("t_manager"); top_managers.Add(new Model.Person()); units = ((App)App.Current).all_data.get_units(); if (card != null) { that_card = card; mode = true; } else { that_card = new Model.Card(); mode = false; } }
/// <summary> /// Set each Card in this object's hand to a blank card. /// </summary> public void BlankHand() { for (int i = 0; i < this.CurrentHand.Length; i++) { Card blankCard = new Model.Card(Card.POSITIONS.Blank, Card.SUITS.Blank); this.CurrentHand[i] = blankCard; OnHandChanged(new HandChangedEventArgs(i, blankCard)); } }
public bool updateReasonSHE(String reason, int selectID, int adminID, int status) { Model.Card card = new Model.Card(); card.Reason = reason; card.Id = selectID; card.Status = status; card.ANumber1 = adminID; return(d_card.update1(card)); }
public IList <CardManage.Model.Card> GetListByWhere(int SelNum, string SqlWhere) { IList <CardManage.Model.Card> listData = new List <CardManage.Model.Card>(); MySqlParameter[] parameters = { new MySqlParameter("@SelNum", MySqlDbType.Int32), new MySqlParameter("@Where_String", MySqlDbType.VarChar) }; parameters[0].Value = SelNum; parameters[1].Value = SqlWhere; DataSet ds = DbHelperSQL.RunProcedure(string.Format("{0}_GetBywhere_Num", this._TableName), parameters, "ds"); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow dRow in ds.Tables[0].Rows) { Model.Card model = new Model.Card() { ID = Functions.FormatInt(dRow["ID"]), RAreaCode = Functions.FormatInt(dRow["RAreaCode"]), RBuildCode = Functions.FormatInt(dRow["RBuildCode"]), RUnitCode = Functions.FormatInt(dRow["RUnitCode"]), RRoomCode = Functions.FormatInt(dRow["RRoomCode"]), CardNo = Functions.FormatUInt(dRow["CardNo"]), CardType = Functions.FormatInt(dRow["CardType"]), CardTypeDesc = Functions.FormatString(dRow["CardTypeDesc"]), SerialNo = Functions.FormatString(dRow["SerialNo"]), ExpiryDate = Functions.FormatInt64(dRow["ExpiryDate"]), IfFrezen = Convert.ToBoolean(dRow["IfFrezen"]), CreateDate = Functions.FormatInt64(dRow["CreateDate"]), Contact = Functions.FormatString(dRow["Contact"]), Tel = Functions.FormatString(dRow["Tel"]), Memo = Functions.FormatString(dRow["Memo"]), RoomID = Functions.FormatInt(dRow["RoomID"]), RoomCode = Functions.FormatInt(dRow["RoomCode"]), RoomName = Functions.FormatString(dRow["RoomName"]), UnitID = Functions.FormatInt(dRow["UnitID"]), UnitCode = Functions.FormatInt(dRow["UnitCode"]), UnitName = Functions.FormatString(dRow["UnitName"]), BuildID = Functions.FormatInt(dRow["BuildID"]), BuildCode = Functions.FormatInt(dRow["BuildCode"]), BuildName = Functions.FormatString(dRow["BuildName"]), AreaID = Functions.FormatInt(dRow["AreaID"]), AreaCode = Functions.FormatInt(dRow["AreaCode"]), AreaName = Functions.FormatString(dRow["AreaName"]) }; listData.Add(model); } } return(listData); }
public bool updateReason(String reason, int selectID, int adminID, int status) { Model.Card card = new Model.Card(); card.Reason = reason; card.UID = selectID; card.Status = status; card.ANumber2 = adminID; card.CardStatus = 1; return(d_card.update(card)); }
public void SetModel(Model.Card card) { model = card; var filename = $"CardImages/{card.Klass}"; var sprite = Resources.Load <Sprite>(filename); if (sprite == null) { Debug.Log($"cant't find such file: {filename}"); } image.sprite = sprite; }
void editCMD(object param) { ((App)App.Current).all_data.stat_it(selectedCard.Id, ((App)App.Current).the_person.Id, "editing card start"); Model.Card tmp = new Model.Card(selectedCard); AddEdit_ViewModel addedvm = new AddEdit_ViewModel(selectedCard); addedvm.ShowDialog(); if (!addedvm.worked) { selectedCard.copy(tmp); } try { System.IO.Directory.Delete(addedvm.catalog, true); } catch { } }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">申请者信息</param> /// <returns>是否更新成功</returns> public bool Update(Model.Card model) { //UID,Status,ANumber1,ANumber2,Reason,CardStatus,GetTimes StringBuilder strSql = new StringBuilder(); strSql.Append("update Card set "); strSql.Append("UID=@UID,"); strSql.Append("Status=@Status,"); strSql.Append("ANumber1=@ANumber1,"); strSql.Append("ANumber2=@ANumber2,"); strSql.Append("Reason=@Reason,"); strSql.Append("CardStatus=@CardStatus,"); strSql.Append("GetTimes=@GetTimes"); strSql.Append(" Where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@UID", SqlDbType.Int), new SqlParameter("@Status", SqlDbType.Int), new SqlParameter("@ANumber1", SqlDbType.Int), new SqlParameter("@ANumber2", SqlDbType.Int), new SqlParameter("@Reason", SqlDbType.VarChar, 500), new SqlParameter("@CardStatus", SqlDbType.Int), new SqlParameter("@GetTimes", SqlDbType.DateTime), new SqlParameter("@ID", SqlDbType.Int) }; parameters[0].Value = model.UID; parameters[1].Value = model.Status; parameters[2].Value = model.ANumber1; parameters[3].Value = model.ANumber2; parameters[4].Value = model.Reason; parameters[5].Value = model.CardStatus; parameters[6].Value = model.GetTimes; parameters[7].Value = model.Id; int rows = DB.DbHelperSQL.ExecuteSql(strSql.ToString(), parameters, DB.DbHelperSQL.maindataConnectionString); if (rows > 0) { return(true); } else { return(false); } }
void execCMD(object param) { Model.Card new_card = null; ((App)App.Current).all_data.stat_it(0, ((App)App.Current).the_person.Id, "button new_card"); AddEdit_ViewModel addedvm = new AddEdit_ViewModel(new_card); addedvm.ShowDialog(); if (addedvm.worked) { cards.Add(addedvm.that_card); } try { System.IO.Directory.Delete(addedvm.catalog, true); } catch { } }
/// <summary> /// 获取用户信息 /// </summary> /// <param name="strSql"></param> /// <returns></returns> public Model.Card GetModel(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from Card "); strSql.Append(" where "); strSql.Append(strWhere); Model.Card model = new Model.Card(); DataSet ds = DB.DbHelperSQL.Query(strSql.ToString(), DB.DbHelperSQL.maindataConnectionString); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public void DisplayCard(Model.Card a_card) { if (a_card.GetColor() == Model.Card.Color.Hidden) { Console.WriteLine("Dolt Kort"); } else { String[] colors = new String[(int)Model.Card.Color.Count] { "Hjärter", "Spader", "Ruter", "Klöver" }; String[] values = new String[(int)Model.Card.Value.Count] { "två", "tre", "fyra", "fem", "sex", "sju", "åtta", "nio", "tio", "knekt", "dam", "kung", "ess" }; Console.WriteLine("{0} {1}", colors[(int)a_card.GetColor()], values[(int)a_card.GetValue()]); } }
/// <summary> /// 根据卡片类别调用名称和用户名,获取卡片信息 /// </summary> /// <param name="callIndex"></param> /// <param name="username"></param> /// <returns></returns> public Model.Card GetUsersCard(string callIndex, string username) { BLL.Card cardBll = new BLL.Card(); BLL.CardCategory cardCategoryBll = new BLL.CardCategory(); BLL.UserCard ucBLL = new BLL.UserCard(); BLL.users usersBll = new BLL.users(); var user = usersBll.GetModel(username); var cardCategory = cardCategoryBll.GetModel(callIndex); var uclist = ucBLL.GetModelList("UserId=" + user.id); var cardList = cardBll.GetModelList("CardCategoryId=" + cardCategory.CardCategoryId); List <Model.UserCard> ucl = (from uc in uclist join c in cardList on uc.CardId equals c.CardId select new Model.UserCard() { UserId = uc.UserId, CardId = uc.CardId, UserCardId = uc.UserCardId, CardCategoryId = cardCategory.CardCategoryId }).ToList(); Model.Card tcard = null; foreach (var uc in ucl) { Model.Card card = cardBll.GetModel(uc.CardId); if (card.StartDate <= DateTime.Now && card.EndDate >= DateTime.Now) { if (tcard != null) { if (tcard.EndDate < card.EndDate) { tcard = card; } } else { tcard = card; } } } return(tcard); }
/// <summary> /// 判断是否可以申请 /// </summary> /// <param name="UID"></param> /// <param name="UTypes"></param> /// <param name="tishi"></param> /// <returns></returns> public bool CanApply(int UID, int UTypes, out string tishi) { Model.ApplyInfo model = new Model.ApplyInfo(); if (!d_apply.Exists("UID=" + UID + " and Types=" + UTypes))//如果不存在该用户的申请信息 { tishi = "apply"; return(true); } else//存在该用户申请信息 { //判断申请状态 model = d_apply.GetModel("UID=" + UID + " and Types=" + UTypes); if (UTypes == 0)//优待卡 { DAL.D_Card d_card = new DAL.D_Card(); Model.Card card = d_card.GetModel("UID=" + UID); if (card != null) { return(CanReapply(card.Status, out tishi)); } else { tishi = "判断是否可以重新申请时出错"; return(false); } } else if (UTypes == 1)//老年津贴 { DAL.D_Money d_money = new DAL.D_Money(); Model.Money money = d_money.GetModel("UID=" + UID); return(CanReapply(money.Status, out tishi)); } else { tishi = "错误"; return(false); } } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.Card DataRowToModel(DataRow row) { //ID,UID,Status,ANumber1,ANumber2,Reason,CardStatus,GetTimes Model.Card model = new Model.Card(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.Id = (int)row["ID"]; } if (row["UID"] != null && row["UID"].ToString() != "") { model.UID = (int)row["UID"]; } if (row["Status"] != null && row["Status"].ToString() != "") { model.Status = (int)row["Status"]; } if (row["ANumber1"] != null && row["ANumber1"].ToString() != "") { model.ANumber1 = (int)row["ANumber1"]; } if (row["ANumber2"] != null && row["ANumber2"].ToString() != "") { model.ANumber2 = (int)row["ANumber2"]; } if (row["Reason"] != null) { model.Reason = row["Reason"].ToString(); } if (row["CardStatus"] != null && row["CardStatus"].ToString() != "") { model.CardStatus = (int)row["CardStatus"]; } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="model">申请者信息</param> /// <returns>是否添加成功</returns> public bool Add(Model.Card model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Card("); strSql.Append("UID,Status,ANumber1,ANumber2,Reason,CardStatus,GetTimes)"); strSql.Append(" values ("); strSql.Append("@UID,@Status,@ANumber1,@ANumber2,@Reason,@CardStatus,@GetTimes)"); SqlParameter[] parameters = { new SqlParameter("@UID", SqlDbType.Int), new SqlParameter("@Status", SqlDbType.Int), new SqlParameter("@ANumber1", SqlDbType.Int), new SqlParameter("@ANumber2", SqlDbType.Int), new SqlParameter("@Reason", SqlDbType.VarChar,500), new SqlParameter("@CardStatus", SqlDbType.Int), new SqlParameter("@GetTimes", SqlDbType.DateTime) }; parameters[0].Value = model.UID; parameters[1].Value = model.Status; parameters[2].Value = model.ANumber1; parameters[3].Value = model.ANumber2; parameters[4].Value = model.Reason; parameters[5].Value = model.CardStatus; parameters[6].Value = model.GetTimes; int rows = DB.DbHelperSQL.ExecuteSql(strSql.ToString(), parameters, DB.DbHelperSQL.maindataConnectionString); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> /// <param name="id">申请人ID</param> /// <returns>申请人信息</returns> public Model.Card GetModel(int uid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from Card "); strSql.Append(" where UID=@UID "); SqlParameter[] parameters = { new SqlParameter("@UID", SqlDbType.Int) }; parameters[0].Value = uid; Model.Card model = new Model.Card(); DataSet ds = DB.DbHelperSQL.Query(strSql.ToString(), parameters, DB.DbHelperSQL.maindataConnectionString); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public void delete_card(Model.Card card) { try { string con_str = Properties.Settings.Default.con_str; SqlConnection connection = new SqlConnection(con_str); connection.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connection; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[dbo].[DeleteCard]"; cmd.Parameters.Add(new SqlParameter("@id", card.Id) { Direction = ParameterDirection.Input }); //cmd.Parameters.Add(new SqlParameter("@status_code",100) { Direction=ParameterDirection.Input}); cmd.ExecuteNonQuery(); ((App)App.Current).all_data.stat_it(card.Id, ((App)App.Current).the_person.Id, "success delete_person"); connection.Close(); } catch (Exception e) { MessageBox.Show(e.ToString()); ((App)App.Current).all_data.stat_it(card.Id, ((App)App.Current).the_person.Id, "fail delete_person"); } }
public void DisplayCard(Model.Card a_card) { Console.WriteLine("{0} of {1}", a_card.GetValue(), a_card.GetColor()); }
public static bool Deploy( Model.Avatar avatarModel, Model.Card card, Vector2 p) { return(instance.zDeploy(avatarModel, card, p)); }
bool zDeploy(Model.Avatar avatarModel, Model.Card card, Vector2 p) { return(stadiumModel.Deploy(avatarModel, card, p)); }
public IHttpActionResult PaySuccess(string ordernum, string tradeno) { var result = new PayResult(); if (ordernum.StartsWith("R")) //充值订单 { BLL.user_recharge bll = new BLL.user_recharge(); Model.user_recharge model = bll.GetModel(ordernum); if (model == null) { result.msg = "该订单号不存在"; result.success = false; result.status = 201; } else { if (model.status == 1) { result.msg = "该订单已经支付,请不要重复支付"; result.success = false; result.status = 202; } //订单编号验证通过后执行 bool r = bll.Confirm(ordernum); if (r) { result.msg = "充值成功"; result.status = 200; result.success = true; } else { result.msg = "充值订单信息更新失败"; result.status = 204; result.success = false; } } } else if (ordernum.StartsWith("B")) { BLL.orders bll = new BLL.orders(); Model.orders model = bll.GetModel(ordernum); if (model == null) { result.msg = "该订单号不存在"; result.success = false; result.status = 201; } else { if (model.payment_status == 2) //已付款 { result.msg = "该订单已经支付,请不要重复支付"; result.success = false; result.status = 202; } //订单编号验证通过后执行 bool r = bll.UpdateField(ordernum, "trade_no='" + tradeno + "',status=2,payment_status=2,payment_time='" + DateTime.Now + "'"); if (r) { var articlebll = new BLL.article(); foreach (var g in model.order_goods) { //判断是否有卡片商品,如果有卡片商品,添加卡片和用户卡片 //todo:此处需要增加事务性操作 if (articlebll.IsCard(g.article_id)) { var article = articlebll.GetModel(g.article_id); string callindex = article.fields["cardcategorycallindex"]; var user = new BLL.users().GetModel(model.user_name); var cardcategory = new BLL.CardCategory().GetModel(callindex); var card = new Model.Card(); card.CardCategoryId = cardcategory.CardCategoryId; card.Code = Utils.GetCheckCode(7); card.CreateDate = DateTime.Now; card.StartDate = DateTime.Now; card.EndDate = DateTime.Now.AddDays((double)cardcategory.Duration); var cardBll = new BLL.Card(); int cardId = cardBll.Add(card); var usercardBll = new BLL.UserCard(); var usercard = new Model.UserCard(); usercard.CardId = cardId; usercard.CardCategoryId = cardcategory.CardCategoryId; usercard.UserId = user.id; usercardBll.Add(usercard); } } result.msg = "支付成功"; result.status = 200; result.success = true; } else { result.msg = "商品订单信息更新失败"; result.status = 204; result.success = false; } } } else { result.msg = "订单号不正确"; result.success = false; result.status = 203; } return(Ok(result)); }
public void edit_card(Model.Card card, List <Model.Card.File> delet, List <Model.Card.File> ad) { try { string con_str = Properties.Settings.Default.con_str; SqlConnection connection = new SqlConnection(con_str); connection.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connection; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[dbo].[EditCard]"; if (card.Top_manager != 0 && card.notificate_top != card.Top_manager) { card.Is_totopmanager = 1; } cmd.Parameters.Add(new SqlParameter("@card_type", card.Card_type) { Direction = ParameterDirection.Input }); cmd.Parameters.Add(new SqlParameter("@n_protocol", card.N_protocol) { Direction = ParameterDirection.Input }); cmd.Parameters.Add(new SqlParameter("@date", card.Date) { Direction = ParameterDirection.Input }); cmd.Parameters.Add(new SqlParameter("@unit", card.Unit) { Direction = ParameterDirection.Input }); cmd.Parameters.Add(new SqlParameter("@responsible_person", card.Responsible_person) { Direction = ParameterDirection.Input }); cmd.Parameters.Add(new SqlParameter("@is_tomanager", card.Is_tomanager) { Direction = ParameterDirection.Input }); cmd.Parameters.Add(new SqlParameter("@unit_manager", card.Unit_manager) { Direction = ParameterDirection.Input }); cmd.Parameters.Add(new SqlParameter("@top_manager", card.Top_manager) { Direction = ParameterDirection.Input }); cmd.Parameters.Add(new SqlParameter("@date_execution", card.Date_execution) { Direction = ParameterDirection.Input }); cmd.Parameters.Add(new SqlParameter("@is_executed", card.Is_executed) { Direction = ParameterDirection.Input }); cmd.Parameters.Add(new SqlParameter("@date_control", card.Date_control) { Direction = ParameterDirection.Input }); cmd.Parameters.Add(new SqlParameter("@is_controlled", card.Is_controlled) { Direction = ParameterDirection.Input }); cmd.Parameters.Add(new SqlParameter("@is_totopmanager", card.Is_totopmanager) { Direction = ParameterDirection.Input }); cmd.Parameters.Add(new SqlParameter("@comment", card.Comment) { Direction = ParameterDirection.Input }); //cmd.Parameters.Add(new SqlParameter("@creator", "0") { Direction = ParameterDirection.Input }); cmd.Parameters.Add(new SqlParameter("@id", card.Id) { Direction = ParameterDirection.Input }); //cmd.Parameters.Add(new SqlParameter("@status_code",100) { Direction=ParameterDirection.Input}); cmd.ExecuteNonQuery(); foreach (var f in delet) { delete_files(card.Id, f.Fname, f.Sname); } load_files(card.Id, card.File_list, ad); ((App)App.Current).all_data.stat_it(card.Id, ((App)App.Current).the_person.Id, "success edit_card"); connection.Close(); } catch (Exception e) { MessageBox.Show(e.ToString()); ((App)App.Current).all_data.stat_it(card.Id, ((App)App.Current).the_person.Id, "fail edit_card"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int uid = (int)Session["UID"]; BLL.B_Card b_card = new BLL.B_Card(); Model.Card model = b_card.GetMoney(uid);//获取审核信息 if (model != null) { switch (model.Status) { case 0: //一级审核失败 lb_Status.Text = "数据不全,一级审核失败,请填写完善资料"; break; case 1: //一级审核成功等待二级审核 lb_Status.Text = "一级审核成功,正在等待二级审核"; break; case 2: //二级审核失败 lb_Status.Text = "二级审核失败..."; lb_Reason.Text = model.Reason; lb_ANumber1.Text = model.ANumber1.ToString(); lb_Reason0.Visible = true; break; case 3: //二级审核成功等待三级审核 lb_Status.Text = "二级审核成功,正在等待三级审核"; lb_ANumber1.Text = model.ANumber1.ToString(); break; case 4: //三级审核失败 lb_Status.Text = "三级审核失败..."; lb_ANumber1.Text = model.ANumber1.ToString(); lb_ANumber2.Text = model.ANumber2.ToString(); lb_Reason.Text = model.Reason; lb_Reason0.Visible = true; break; case 5: //审核成功 lb_Status.Text = "恭喜你,审核通过!"; lb_ANumber1.Text = model.ANumber1.ToString(); lb_ANumber2.Text = model.ANumber2.ToString(); //查看制卡状态 switch (model.CardStatus) { case 0: case 1: lb_zktypes.Text = ""; break; case 2: lb_zktypes.Text = "优待卡制作中..."; break; case 3: lb_zktypes.Text = "优待卡已制作完成,待领取!"; break; case 4: lb_zktypes.Text = "已领取!"; lb_zktypes.ForeColor = System.Drawing.Color.Red; break; default: break; } break; default: break; } } else { webclass.Show(this, "您还未申请优待卡,快去申请吧!"); } } }
private void EditInitData() { IDAL.ICard objDAL = DALFactory.DALFactory.Card(); Model.Card objModel = objDAL.GetModel(this._CurrentID); if (objModel != null) { txtCardNo.Text = objModel.CardNo.ToString(); txtRAreaCode.Text = FormatBuildingCode(objModel.RAreaCode); txtRBuildCode.Text = FormatBuildingCode(objModel.RBuildCode); txtRUnitCode.Text = FormatBuildingCode(objModel.RUnitCode); cbAreaCode.Items.Add(string.Format("{0}|{1:D2}", objModel.AreaName, objModel.RAreaCode)); cbBuildCode.Items.Add(string.Format("{0}|{1:D2}", objModel.BuildName, objModel.RBuildCode)); cbUnitCode.Items.Add(string.Format("{0}|{1:D2}", objModel.UnitName, objModel.RUnitCode)); cbFloorCode.Items.Add(string.Format("{0}|{1:D4}", objModel.RoomName, objModel.RRoomCode)); cbAreaCode.SelectedIndex = 0; cbBuildCode.SelectedIndex = 0; cbUnitCode.SelectedIndex = 0; cbFloorCode.SelectedIndex = 0; string strRoomCode = FormatRoomCode(objModel.RRoomCode); txtRFloorCode.Text = strRoomCode.Substring(0, 2); txtRRoomCode.Text = strRoomCode.Substring(2, 2); txtSerialNo.Text = objModel.SerialNo; cbCardType.Items.Add(new Model.ComboBoxItem("请选择卡类型", -1)); cbCardType.Items.Add(new Model.ComboBoxItem("用户卡", 0)); cbCardType.Items.Add(new Model.ComboBoxItem("巡更卡", 1)); cbCardType.Items.Add(new Model.ComboBoxItem("管理卡", 2)); cbCardType.SelectedIndex = objModel.CardType + 1; txtContact.Text = objModel.Contact; txtTel.Text = objModel.Tel; txtMemo.Text = objModel.Memo; dtExpiryDate.Value = Functions.ConvertToNormalTime(objModel.ExpiryDate); cbEndDate.Visible = false; string strBelongDesc = "未归属"; if (!objModel.AreaName.Equals("")) { strBelongDesc = ""; strBelongDesc += string.Format("{0}", objModel.AreaName); if (!objModel.BuildName.Equals("")) { strBelongDesc += string.Format("=>{0}", objModel.BuildName); if (!objModel.UnitName.Equals("")) { strBelongDesc += string.Format("=>{0}", objModel.UnitName); if (!objModel.RoomName.Equals("")) { strBelongDesc += string.Format("=>{0}", objModel.RoomName); } } } } txtBelongDesc.Text = strBelongDesc; } //一些控件设置为不可变,隐藏部分控件 SetReadOnly(); }
public void add_card(Model.Card card, long creator, List <Model.Card.File> ad) { try { string con_str = Properties.Settings.Default.con_str; SqlConnection connection = new SqlConnection(con_str); connection.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connection; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[dbo].[CreateNewCard]"; if (card.Top_manager != 0 && card.notificate_top != card.Top_manager) { card.Is_totopmanager = 1; } cmd.Parameters.Add(new SqlParameter("@card_type", card.Card_type) { Direction = ParameterDirection.Input }); cmd.Parameters.Add(new SqlParameter("@n_protocol", card.N_protocol) { Direction = ParameterDirection.Input }); cmd.Parameters.Add(new SqlParameter("@date", card.Date) { Direction = ParameterDirection.Input }); cmd.Parameters.Add(new SqlParameter("@unit", card.Unit) { Direction = ParameterDirection.Input }); cmd.Parameters.Add(new SqlParameter("@responsible_person", card.Responsible_person) { Direction = ParameterDirection.Input }); cmd.Parameters.Add(new SqlParameter("@is_tomanager", card.Is_tomanager) { Direction = ParameterDirection.Input }); cmd.Parameters.Add(new SqlParameter("@unit_manager", card.Unit_manager) { Direction = ParameterDirection.Input }); cmd.Parameters.Add(new SqlParameter("@top_manager", card.Top_manager) { Direction = ParameterDirection.Input }); cmd.Parameters.Add(new SqlParameter("@date_execution", card.Date_execution) { Direction = ParameterDirection.Input }); cmd.Parameters.Add(new SqlParameter("@is_executed", card.Is_executed) { Direction = ParameterDirection.Input }); cmd.Parameters.Add(new SqlParameter("@date_control", card.Date_control) { Direction = ParameterDirection.Input }); cmd.Parameters.Add(new SqlParameter("@is_controlled", card.Is_controlled) { Direction = ParameterDirection.Input }); cmd.Parameters.Add(new SqlParameter("@is_totopmanager", card.Is_totopmanager) { Direction = ParameterDirection.Input }); cmd.Parameters.Add(new SqlParameter("@comment", card.Comment) { Direction = ParameterDirection.Input }); cmd.Parameters.Add(new SqlParameter("@creator", creator) { Direction = ParameterDirection.Input }); cmd.Parameters.Add(new SqlParameter("@id", card.Id) { Direction = ParameterDirection.Output }); cmd.Parameters.Add(new SqlParameter("@is_startrecieve", '0') { Direction = ParameterDirection.Input }); //cmd.Parameters.Add(new SqlParameter("@status_code",100) { Direction=ParameterDirection.Input}); cmd.ExecuteNonQuery(); card.Id = Convert.ToInt64(cmd.Parameters["@id"].Value); if (ad.Count != 0) { load_files(card.Id, card.File_list, ad); } ((App)App.Current).all_data.stat_it(card.Id, ((App)App.Current).the_person.Id, "success add_card"); connection.Close(); } catch (Exception e) { MessageBox.Show(e.ToString()); ((App)App.Current).all_data.stat_it(card.Id, ((App)App.Current).the_person.Id, "fail add_card"); } // receive_mail(card.Id); }