/// <summary> /// 临时增加身份证,用来最后转入房间 /// </summary> /// <returns></returns> public string add_ls_sfz() { string result_0 = ""; string tBkrxm = ""; string tBkrxb = ""; string tBnation = ""; string tBadd = ""; string tBid = ""; string tBkrsr = ""; string tBdepart = ""; string tBstart = ""; string tBend = ""; bool sh_massage = false; string massage_nr = ""; byte[] imakrxp = new byte[0]; get_sfz_info(ref tBkrxm, ref tBkrxb, ref tBnation, ref tBadd, ref tBid, ref tBkrsr, ref tBdepart, ref tBstart, ref tBend, ref imakrxp, sh_massage, ref massage_nr); result_0 = massage_nr; if (tBkrxm != "") { BLL.Common B_Common = new Hotel_app.BLL.Common(); DataSet DS_temp = B_Common.GetList("select * from Q_sfz_temp", " zjhm='" + tBid + "' and shcl=0"); if (DS_temp != null && DS_temp.Tables[0].Rows.Count > 0) { } else { BLL.Q_sfz_temp B_Q_sfz_temp = new Hotel_app.BLL.Q_sfz_temp(); Model.Q_sfz_temp M_Q_sfz_temp = new Hotel_app.Model.Q_sfz_temp(); M_Q_sfz_temp.zjhm = tBid; M_Q_sfz_temp.krxm = tBkrxm; M_Q_sfz_temp.krxb = tBkrxb; M_Q_sfz_temp.krmz = tBnation; M_Q_sfz_temp.krdz = tBadd; M_Q_sfz_temp.krsr = DateTime.Parse(tBkrsr.Substring(0, 4) + "-" + tBkrsr.Substring(4, 2) + "-" + tBkrsr.Substring(6, 2)); M_Q_sfz_temp.department = tBdepart; if (tBstart.Length > 7) { M_Q_sfz_temp.startdate = DateTime.Parse(tBstart.Substring(0, 4) + "-" + tBstart.Substring(4, 2) + "-" + tBstart.Substring(6, 2)); } else { M_Q_sfz_temp.startdate = DateTime.Parse(common_file.common_app.cssj); } if (tBend.Length > 8)//注意:这个字段有个可能是:长期 这样一个值,不一这下是时间 { M_Q_sfz_temp.enddate = DateTime.Parse(tBend.Substring(0, 4) + "-" + tBend.Substring(4, 2) + "-" + tBend.Substring(6, 2)); } else { M_Q_sfz_temp.enddate = DateTime.Parse(common_file.common_app.cssj); } M_Q_sfz_temp.krxp = imakrxp; B_Q_sfz_temp.Add(M_Q_sfz_temp); } } return(result_0); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Hotel_app.Model.Q_sfz_temp model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Q_sfz_temp("); strSql.Append("zjhm,krxm,krmz,krxb,krsr,krdz,department,startdate,enddate,krxp,shcl,czsj,fjbh)"); strSql.Append(" values ("); strSql.Append("@zjhm,@krxm,@krmz,@krxb,@krsr,@krdz,@department,@startdate,@enddate,@krxp,@shcl,@czsj,@fjbh)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@zjhm", SqlDbType.VarChar, 50), new SqlParameter("@krxm", SqlDbType.VarChar, 50), new SqlParameter("@krmz", SqlDbType.VarChar, 50), new SqlParameter("@krxb", SqlDbType.VarChar, 50), new SqlParameter("@krsr", SqlDbType.DateTime), new SqlParameter("@krdz", SqlDbType.VarChar, 200), new SqlParameter("@department", SqlDbType.VarChar, 50), new SqlParameter("@startdate", SqlDbType.DateTime), new SqlParameter("@enddate", SqlDbType.DateTime), new SqlParameter("@krxp", SqlDbType.Image), new SqlParameter("@shcl", SqlDbType.Bit, 1), new SqlParameter("@czsj", SqlDbType.DateTime), new SqlParameter("@fjbh", SqlDbType.VarChar, 50) }; parameters[0].Value = model.zjhm; parameters[1].Value = model.krxm; parameters[2].Value = model.krmz; parameters[3].Value = model.krxb; parameters[4].Value = model.krsr; parameters[5].Value = model.krdz; parameters[6].Value = model.department; parameters[7].Value = model.startdate; parameters[8].Value = model.enddate; parameters[9].Value = model.krxp; parameters[10].Value = model.shcl; parameters[11].Value = model.czsj; parameters[12].Value = model.fjbh; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Hotel_app.Model.Q_sfz_temp GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,zjhm,krxm,krmz,krxb,krsr,krdz,department,startdate,enddate,krxp,shcl,czsj,fjbh from Q_sfz_temp "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Hotel_app.Model.Q_sfz_temp model = new Hotel_app.Model.Q_sfz_temp(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["zjhm"] != null && ds.Tables[0].Rows[0]["zjhm"].ToString() != "") { model.zjhm = ds.Tables[0].Rows[0]["zjhm"].ToString(); } if (ds.Tables[0].Rows[0]["krxm"] != null && ds.Tables[0].Rows[0]["krxm"].ToString() != "") { model.krxm = ds.Tables[0].Rows[0]["krxm"].ToString(); } if (ds.Tables[0].Rows[0]["krmz"] != null && ds.Tables[0].Rows[0]["krmz"].ToString() != "") { model.krmz = ds.Tables[0].Rows[0]["krmz"].ToString(); } if (ds.Tables[0].Rows[0]["krxb"] != null && ds.Tables[0].Rows[0]["krxb"].ToString() != "") { model.krxb = ds.Tables[0].Rows[0]["krxb"].ToString(); } if (ds.Tables[0].Rows[0]["krsr"] != null && ds.Tables[0].Rows[0]["krsr"].ToString() != "") { model.krsr = DateTime.Parse(ds.Tables[0].Rows[0]["krsr"].ToString()); } if (ds.Tables[0].Rows[0]["krdz"] != null && ds.Tables[0].Rows[0]["krdz"].ToString() != "") { model.krdz = ds.Tables[0].Rows[0]["krdz"].ToString(); } if (ds.Tables[0].Rows[0]["department"] != null && ds.Tables[0].Rows[0]["department"].ToString() != "") { model.department = ds.Tables[0].Rows[0]["department"].ToString(); } if (ds.Tables[0].Rows[0]["startdate"] != null && ds.Tables[0].Rows[0]["startdate"].ToString() != "") { model.startdate = DateTime.Parse(ds.Tables[0].Rows[0]["startdate"].ToString()); } if (ds.Tables[0].Rows[0]["enddate"] != null && ds.Tables[0].Rows[0]["enddate"].ToString() != "") { model.enddate = DateTime.Parse(ds.Tables[0].Rows[0]["enddate"].ToString()); } if (ds.Tables[0].Rows[0]["krxp"] != null && ds.Tables[0].Rows[0]["krxp"].ToString() != "") { model.krxp = (byte[])ds.Tables[0].Rows[0]["krxp"]; } if (ds.Tables[0].Rows[0]["shcl"] != null && ds.Tables[0].Rows[0]["shcl"].ToString() != "") { if ((ds.Tables[0].Rows[0]["shcl"].ToString() == "1") || (ds.Tables[0].Rows[0]["shcl"].ToString().ToLower() == "true")) { model.shcl = true; } else { model.shcl = false; } } if (ds.Tables[0].Rows[0]["czsj"] != null && ds.Tables[0].Rows[0]["czsj"].ToString() != "") { model.czsj = DateTime.Parse(ds.Tables[0].Rows[0]["czsj"].ToString()); } if (ds.Tables[0].Rows[0]["fjbh"] != null && ds.Tables[0].Rows[0]["fjbh"].ToString() != "") { model.fjbh = ds.Tables[0].Rows[0]["fjbh"].ToString(); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Hotel_app.Model.Q_sfz_temp model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Q_sfz_temp set "); strSql.Append("zjhm=@zjhm,"); strSql.Append("krxm=@krxm,"); strSql.Append("krmz=@krmz,"); strSql.Append("krxb=@krxb,"); strSql.Append("krsr=@krsr,"); strSql.Append("krdz=@krdz,"); strSql.Append("department=@department,"); strSql.Append("startdate=@startdate,"); strSql.Append("enddate=@enddate,"); strSql.Append("krxp=@krxp,"); strSql.Append("shcl=@shcl,"); strSql.Append("czsj=@czsj,"); strSql.Append("fjbh=@fjbh"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@zjhm", SqlDbType.VarChar, 50), new SqlParameter("@krxm", SqlDbType.VarChar, 50), new SqlParameter("@krmz", SqlDbType.VarChar, 50), new SqlParameter("@krxb", SqlDbType.VarChar, 50), new SqlParameter("@krsr", SqlDbType.DateTime), new SqlParameter("@krdz", SqlDbType.VarChar, 200), new SqlParameter("@department", SqlDbType.VarChar, 50), new SqlParameter("@startdate", SqlDbType.DateTime), new SqlParameter("@enddate", SqlDbType.DateTime), new SqlParameter("@krxp", SqlDbType.Image), new SqlParameter("@shcl", SqlDbType.Bit, 1), new SqlParameter("@czsj", SqlDbType.DateTime), new SqlParameter("@fjbh", SqlDbType.VarChar, 50), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.zjhm; parameters[1].Value = model.krxm; parameters[2].Value = model.krmz; parameters[3].Value = model.krxb; parameters[4].Value = model.krsr; parameters[5].Value = model.krdz; parameters[6].Value = model.department; parameters[7].Value = model.startdate; parameters[8].Value = model.enddate; parameters[9].Value = model.krxp; parameters[10].Value = model.shcl; parameters[11].Value = model.czsj; parameters[12].Value = model.fjbh; parameters[13].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public void FillData() { try { if (IsInitComOK()) { int authenticate = CVR_Authenticate(); if (authenticate == 1) { int readContent = CVR_Read_Content(4); if (readContent == 1) { byte[] name = new byte[30]; int length = 30; GetPeopleName(ref name[0], ref length); byte[] number = new byte[30]; length = 36; GetPeopleIDCode(ref number[0], ref length); byte[] people = new byte[30]; length = 3; GetPeopleNation(ref people[0], ref length); byte[] validtermOfStart = new byte[30]; length = 16; GetStartDate(ref validtermOfStart[0], ref length); byte[] birthday = new byte[30]; length = 16; GetPeopleBirthday(ref birthday[0], ref length); byte[] address = new byte[30]; length = 70; GetPeopleAddress(ref address[0], ref length); byte[] validtermOfEnd = new byte[30]; length = 16; GetEndDate(ref validtermOfEnd[0], ref length); byte[] signdate = new byte[30]; length = 30; GetDepartment(ref signdate[0], ref length); byte[] sex = new byte[30]; length = 3; GetPeopleSex(ref sex[0], ref length); byte[] samid = new byte[32]; CVR_GetSAMID(ref samid[0]); //生成了照片 if (File.Exists(Application.StartupPath + "\\zp.bmp")) { if (!File.Exists(Application.StartupPath + "\\imgsfz\\" + System.Text.Encoding.GetEncoding("GB2312").GetString(number).Replace("\0", "").Trim() + ".bmp")) { File.Copy(Application.StartupPath + "\\zp.bmp", Application.StartupPath + "\\imgsfz\\" + System.Text.Encoding.GetEncoding("GB2312").GetString(number).Replace("\0", "").Trim() + ".bmp", true); } } //pb_photo.ImageLocation = Application.StartupPath + "\\imgsfz\\" + tBid_0.Text + ".bmp"; //检测临时表是否有存储当前客户的信息 BLL.Q_sfz_temp bll = new Hotel_app.BLL.Q_sfz_temp(); List <Model.Q_sfz_temp> lists = bll.GetModelList(" zjhm='" + System.Text.Encoding.GetEncoding("GB2312").GetString(number).Replace("\0", "").Trim() + "' and shcl=0"); if (lists != null && lists.Count > 0) { } else { //ADD Model To Q_sfz_temp Model.Q_sfz_temp M_Q_sfz_temp = new Hotel_app.Model.Q_sfz_temp(); M_Q_sfz_temp.zjhm = System.Text.Encoding.GetEncoding("GB2312").GetString(number).Replace("\0", "").Trim(); M_Q_sfz_temp.krxm = System.Text.Encoding.GetEncoding("GB2312").GetString(name).Replace("\0", "").Trim(); M_Q_sfz_temp.krxb = System.Text.Encoding.GetEncoding("GB2312").GetString(sex).Replace("\0", "").Trim(); M_Q_sfz_temp.krmz = System.Text.Encoding.GetEncoding("GB2312").GetString(people).Replace("\0", "").Trim(); M_Q_sfz_temp.krdz = System.Text.Encoding.GetEncoding("GB2312").GetString(address).Replace("\0", "").Trim(); M_Q_sfz_temp.krsr = DateTime.Parse(System.Text.Encoding.GetEncoding("GB2312").GetString(birthday).Replace("\0", "").Trim()); M_Q_sfz_temp.department = System.Text.Encoding.GetEncoding("GB2312").GetString(signdate).Replace("\0", "").Trim(); M_Q_sfz_temp.startdate = DateTime.Parse(System.Text.Encoding.GetEncoding("GB2312").GetString(validtermOfStart).Replace("\0", "").Trim()); M_Q_sfz_temp.enddate = DateTime.Parse(System.Text.Encoding.GetEncoding("GB2312").GetString(validtermOfEnd).Replace("\0", "").Trim()); if (File.Exists(Application.StartupPath + "\\imgsfz\\" + System.Text.Encoding.GetEncoding("GB2312").GetString(number).Replace("\0", "").Trim() + ".bmp")) { M_Q_sfz_temp.krxp = Maticsoft.Common.FileToByte.FileContent(Application.StartupPath + "\\imgsfz\\" + System.Text.Encoding.GetEncoding("GB2312").GetString(number).Replace("\0", "").Trim() + ".bmp"); } bll.Add(M_Q_sfz_temp); } } else { MessageBox.Show("读卡操作失败,请拿开卡片重试."); } } else { MessageBox.Show("未放卡或卡片放置不正确,请拿开卡片重试"); } CVR_CloseComm(); } else { MessageBox.Show("初始化失败!"); } } catch (Exception ex) { System.Windows.Forms.MessageBox.Show(ex.ToString()); } }