public static Entity.Join_Card Join_CardEntityGetByCardBank(string CardBank) { Entity.Join_Card info = new Entity.Join_Card(); DataTable dt = SqlDB.ExecuteDataset(strCon, CommandType.Text, "SELECT * FROM [Join_Card] WHERE CardBank = '" + CardBank + "'").Tables[0]; if (dt.Rows.Count > 0) { info.CardId = Basic.Utils.StrToInt(dt.Rows[0]["CardId"].ToString(), 0); info.CardBank = dt.Rows[0]["CardBank"].ToString(); info.CardPass = dt.Rows[0]["CardPass"].ToString(); info.IsValid = Basic.Utils.StrToInt(dt.Rows[0]["IsValid"].ToString(), 0); info.UseState = Basic.Utils.StrToInt(dt.Rows[0]["UseState"].ToString(), 0); info.DianId = Basic.Utils.StrToInt(dt.Rows[0]["DianId"].ToString(), 0); info.ProvinceId = Basic.Utils.StrToInt(dt.Rows[0]["ProvinceId"].ToString(), 0); info.StudentId = Basic.Utils.StrToInt(dt.Rows[0]["StudentId"].ToString(), 0); info.UseIp = dt.Rows[0]["UseIp"].ToString(); info.IsTest = Basic.Utils.StrToInt(dt.Rows[0]["IsTest"].ToString(), 0); info.OpenCardTime = Basic.TypeConverter.StrToDateTime(dt.Rows[0]["OpenCardTime"].ToString()); info.UseTime = Basic.TypeConverter.StrToDateTime(dt.Rows[0]["UseTime"].ToString()); return(info); } else { return(null); } }
public static Entity.Join_Card Join_CardEntityGetByCardBank(string CardBank, string CardPass) { Entity.Join_Card info = new Entity.Join_Card(); SqlParameter[] prams = { SqlDB.MakeInParam("@CardBank", SqlDbType.NVarChar, 100, CardBank), SqlDB.MakeInParam("@CardPass", SqlDbType.NVarChar, 50, CardPass), }; DataTable dt = SqlDB.ExecuteDataset(strCon, CommandType.StoredProcedure, "Join_CardEntityGet", prams).Tables[0]; //DataTable dt = SqlDB.ExecuteDataset(strCon, CommandType.Text, "SELECT * FROM [Join_Card] WHERE CardBank = '" + CardBank + "' AND CardPass = '******'").Tables[0]; if (dt.Rows.Count > 0) { info.CardId = Basic.Utils.StrToInt(dt.Rows[0]["CardId"].ToString(), 0); info.CardBank = dt.Rows[0]["CardBank"].ToString(); info.CardPass = dt.Rows[0]["CardPass"].ToString(); info.IsValid = Basic.Utils.StrToInt(dt.Rows[0]["IsValid"].ToString(), 0); info.UseState = Basic.Utils.StrToInt(dt.Rows[0]["UseState"].ToString(), 0); info.DianId = Basic.Utils.StrToInt(dt.Rows[0]["DianId"].ToString(), 0); info.ProvinceId = Basic.Utils.StrToInt(dt.Rows[0]["ProvinceId"].ToString(), 0); info.StudentId = Basic.Utils.StrToInt(dt.Rows[0]["StudentId"].ToString(), 0); info.UseIp = dt.Rows[0]["UseIp"].ToString(); info.IsTest = Basic.Utils.StrToInt(dt.Rows[0]["IsTest"].ToString(), 0); info.OpenCardTime = Basic.TypeConverter.StrToDateTime(dt.Rows[0]["OpenCardTime"].ToString()); info.UseTime = Basic.TypeConverter.StrToDateTime(dt.Rows[0]["UseTime"].ToString()); info.OpenCardTime = Basic.TypeConverter.StrToDateTime(dt.Rows[0]["OpenCardTime"].ToString()); info.UseTime = Basic.TypeConverter.StrToDateTime(dt.Rows[0]["UseTime"].ToString()); return(info); } else { return(null); } }