public static Boolean login(String userno, String password) { DB db = new DB(); long count = db.GetCount(String.Format("SELECT COUNT(*) FROM user_info WHERE user_no='{0}' AND password='******'", userno, Utils.md5(password))); if(count == 1) { return true; } else { return false; } }
public static Boolean login(String userno, String password) { DB db = new DB(); long count = db.GetCount(String.Format("SELECT COUNT(*) FROM user_info WHERE user_no='{0}' AND password='******'", userno, Utils.md5(password))); if (count == 1) { return(true); } else { return(false); } }
/// <summary> // 生成制卡文件后要提交数据库,某集团的某批次已制卡完成 /// </summary> /// <param name="unitNum"></param> /// <param name="batchNum"></param> /// <returns></returns> public static Boolean CommitGenFile(String unitNum, int batchNum) { DB db = new DB(); db.Conn.Open(); NpgsqlTransaction transaction = db.Conn.BeginTransaction(); //DataTable dt = new DataTable(); long count = db.GetCount(String.Format("SELECT COUNT(*) FROM card_batch_info WHERE file_generated=true AND unit_no='{0}' AND batch_no={1}", unitNum, batchNum)); if (count == 0) { // card_kind: 卡类型 0:磁条卡 1:IC接解卡 2:IC非接触 // card_type: 卡种类 0:系统卡 1:自发卡 db.ExecSql(String.Format("INSERT INTO card_info(card_no, card_kind, password, status, amount, points_rule, exp_date, points, unit_no, track_2, valid_life, card_type) (SELECT card_no, card_kind, md5(password), status, amount, points_rule, exp_date, points, unit_no, track_2, valid_life, '0' FROM tmp_card_info WHERE unit_no = '{0}' AND batch_no = {1})", unitNum, batchNum)); db.ExecSql(String.Format("UPDATE card_batch_info SET file_generated=true WHERE unit_no='{0}' AND batch_no={1}", unitNum, batchNum)); } transaction.Commit(); db.Conn.Close(); return true; }
/// <summary> // 生成制卡文件后要提交数据库,某集团的某批次已制卡完成 /// </summary> /// <param name="unitNum"></param> /// <param name="batchNum"></param> /// <returns></returns> public static Boolean CommitGenFile(String unitNum, int batchNum) { DB db = new DB(); db.Conn.Open(); NpgsqlTransaction transaction = db.Conn.BeginTransaction(); //DataTable dt = new DataTable(); long count = db.GetCount(String.Format("SELECT COUNT(*) FROM card_batch_info WHERE file_generated=true AND unit_no='{0}' AND batch_no={1}", unitNum, batchNum)); if (count == 0) { // card_kind: 卡类型 0:磁条卡 1:IC接解卡 2:IC非接触 // card_type: 卡种类 0:系统卡 1:自发卡 db.ExecSql(String.Format("INSERT INTO card_info(card_no, card_kind, password, status, amount, points_rule, exp_date, points, unit_no, track_2, valid_life, card_type) (SELECT card_no, card_kind, md5(password), status, amount, points_rule, exp_date, points, unit_no, track_2, valid_life, '0' FROM tmp_card_info WHERE unit_no = '{0}' AND batch_no = {1})", unitNum, batchNum)); db.ExecSql(String.Format("UPDATE card_batch_info SET file_generated=true WHERE unit_no='{0}' AND batch_no={1}", unitNum, batchNum)); } transaction.Commit(); db.Conn.Close(); return(true); }