public string PersonerInfo(string CardSn) { StringBuilder sb = new StringBuilder(); try { if (ConfigurationManager.AppSettings["CofeePosCardType"] == "1") { CardSn = (100000000 + DeCode1(CardSn)).ToString().Remove(0, 1); } string ConnString = ConfigurationManager.AppSettings["cfsf"]; nrWebClass.DAL.SqlDbHelper dal = new nrWebClass.DAL.SqlDbHelper(ConnString); SqlParameter[] paramters = new SqlParameter[] { new SqlParameter("@CardSn", int.Parse(CardSn)) }; LiLanzDAL dal2 = new LiLanzDAL(); using (IDataReader reader = dal.ExecuteReader(@"select t2.DeptName,CardSnr,CustomerName, t1.CustomerNo,t2.DeptNo,t1.AccountNo,isnull(t1.AccStat,0),isnull(t1.CardStat,0),t1.sex from tb_Customer_coffee as t1 inner join tb_Department as t2 on t1.DeptNo=t2.DeptNo where CardSnr=@CardSn", CommandType.Text, paramters)) { if (reader.Read()) { if (reader[6].ToString() == "0" && reader[7].ToString() == "0") { int isLeave = 0; if (IsLeave(reader[5].ToString())) { isLeave = 1; } sb.Append("<?xml version=\"1.0\" encoding=\"gb2312\"?>"); sb.Append(String.Format("<CardInfo Dept=\"{0}\" CardNo=\"{1}\" Cname=\"{2}\" PersonSn=\"{3}\" DeptNo=\"{4}\" AccountNo=\"{5}\" Sex=\"{6}\" isLeave=\"{7}\">", reader[0], CardSnFill(reader[1].ToString()), reader[2], reader[3], reader[4], reader[5], reader["sex"], isLeave)); sb.Append("</CardInfo>"); } //SqlParameter[] paramters2 = new SqlParameter[]{ // new SqlParameter("@AccountNo", int.Parse(reader[5].ToString())) //}; //if (dal2.ExecuteScalar("select 1 from cy_t_coffeeStopSign where AccountNo=@AccountNo", // CommandType.Text, paramters2) != null) // sb.Length = 0; } reader.Dispose(); } } catch (Exception ex) { sb.Append(ex.ToString()); } return(sb.ToString()); }
public string PersonerInfoNoEncrypt(string CardSn) { StringBuilder sb = new StringBuilder(); try { string ConnString = ConfigurationManager.AppSettings["cfsf"]; nrWebClass.DAL.SqlDbHelper dal = new nrWebClass.DAL.SqlDbHelper(ConnString); SqlParameter[] paramters = new SqlParameter[] { new SqlParameter("@CardSn", int.Parse(CardSn)) }; IDataReader reader = dal.ExecuteReader(@"select t2.DeptName,CardSnr,CustomerName, t1.CustomerNo,t2.DeptNo,t1.AccountNo,isnull(t1.AccStat,0) AccStat,isnull(t1.CardStat,0) CardStat,t1.sex from tb_Customer_coffee as t1 inner join tb_Department as t2 on t1.DeptNo=t2.DeptNo where CardSnr=@CardSn", CommandType.Text, paramters); if (reader.Read()) { if (reader[6].ToString() == "0" && reader[7].ToString() == "0") { int isLeave = 0; if (IsLeave(reader[5].ToString())) { isLeave = 1; } //Log.Info(IsLeave(reader[5].ToString()).ToString()); sb.Append("<?xml version=\"1.0\" encoding=\"gb2312\"?>"); sb.Append(String.Format("<CardInfo Dept=\"{0}\" CardNo=\"{1}\" Cname=\"{2}\" PersonSn=\"{3}\" DeptNo=\"{4}\" AccountNo=\"{5}\" Sex=\"{6}\" isLeave=\"{7}\">", reader[0], CardSnFill(reader[1].ToString()), reader[2], reader[3], reader[4], reader[5], reader["sex"], isLeave)); sb.Append("</CardInfo>"); } } reader.Dispose(); } catch (Exception ex) { sb.Append(ex.ToString()); } finally { } return(sb.ToString()); }