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