/// <summary> /// 得到一个对象实体 /// </summary> public MyTest.Model.Sys_UserLogOnModel GetModel(string F_Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 F_Id,F_UserId,F_UserPassword,F_UserSecretkey,F_AllowStartTime,F_AllowEndTime,F_LockStartDate,F_LockEndDate,F_FirstVisitTime,F_PreviousVisitTime,F_LastVisitTime,F_ChangePasswordDate,F_MultiUserLogin,F_LogOnCount,F_UserOnLine,F_Question,F_AnswerQuestion,F_CheckIPAddress,F_Language,F_Theme from Sys_UserLogOn "); strSql.Append(" where F_Id=@F_Id "); SqlParameter[] parameters = { new SqlParameter("@F_Id", SqlDbType.VarChar, 50) }; parameters[0].Value = F_Id; MyTest.Model.Sys_UserLogOnModel model = new MyTest.Model.Sys_UserLogOnModel(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(MyTest.Model.Sys_UserLogOnModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Sys_UserLogOn("); strSql.Append("F_Id,F_UserId,F_UserPassword,F_UserSecretkey,F_AllowStartTime,F_AllowEndTime,F_LockStartDate,F_LockEndDate,F_FirstVisitTime,F_PreviousVisitTime,F_LastVisitTime,F_ChangePasswordDate,F_MultiUserLogin,F_LogOnCount,F_UserOnLine,F_Question,F_AnswerQuestion,F_CheckIPAddress,F_Language,F_Theme)"); strSql.Append(" values ("); strSql.Append("@F_Id,@F_UserId,@F_UserPassword,@F_UserSecretkey,@F_AllowStartTime,@F_AllowEndTime,@F_LockStartDate,@F_LockEndDate,@F_FirstVisitTime,@F_PreviousVisitTime,@F_LastVisitTime,@F_ChangePasswordDate,@F_MultiUserLogin,@F_LogOnCount,@F_UserOnLine,@F_Question,@F_AnswerQuestion,@F_CheckIPAddress,@F_Language,@F_Theme)"); SqlParameter[] parameters = { new SqlParameter("@F_Id", SqlDbType.VarChar, 50), new SqlParameter("@F_UserId", SqlDbType.VarChar, 50), new SqlParameter("@F_UserPassword", SqlDbType.VarChar, 50), new SqlParameter("@F_UserSecretkey", SqlDbType.VarChar, 50), new SqlParameter("@F_AllowStartTime", SqlDbType.DateTime), new SqlParameter("@F_AllowEndTime", SqlDbType.DateTime), new SqlParameter("@F_LockStartDate", SqlDbType.DateTime), new SqlParameter("@F_LockEndDate", SqlDbType.DateTime), new SqlParameter("@F_FirstVisitTime", SqlDbType.DateTime), new SqlParameter("@F_PreviousVisitTime", SqlDbType.DateTime), new SqlParameter("@F_LastVisitTime", SqlDbType.DateTime), new SqlParameter("@F_ChangePasswordDate", SqlDbType.DateTime), new SqlParameter("@F_MultiUserLogin", SqlDbType.Bit, 1), new SqlParameter("@F_LogOnCount", SqlDbType.Int, 4), new SqlParameter("@F_UserOnLine", SqlDbType.Bit, 1), new SqlParameter("@F_Question", SqlDbType.VarChar, 50), new SqlParameter("@F_AnswerQuestion", SqlDbType.VarChar, 500), new SqlParameter("@F_CheckIPAddress", SqlDbType.Bit, 1), new SqlParameter("@F_Language", SqlDbType.VarChar, 50), new SqlParameter("@F_Theme", SqlDbType.VarChar, 50) }; parameters[0].Value = model.F_Id; parameters[1].Value = model.F_UserId; parameters[2].Value = model.F_UserPassword; parameters[3].Value = model.F_UserSecretkey; parameters[4].Value = model.F_AllowStartTime; parameters[5].Value = model.F_AllowEndTime; parameters[6].Value = model.F_LockStartDate; parameters[7].Value = model.F_LockEndDate; parameters[8].Value = model.F_FirstVisitTime; parameters[9].Value = model.F_PreviousVisitTime; parameters[10].Value = model.F_LastVisitTime; parameters[11].Value = model.F_ChangePasswordDate; parameters[12].Value = model.F_MultiUserLogin; parameters[13].Value = model.F_LogOnCount; parameters[14].Value = model.F_UserOnLine; parameters[15].Value = model.F_Question; parameters[16].Value = model.F_AnswerQuestion; parameters[17].Value = model.F_CheckIPAddress; parameters[18].Value = model.F_Language; parameters[19].Value = model.F_Theme; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public MyTest.Model.Sys_UserLogOnModel DataRowToModel(DataRow row) { MyTest.Model.Sys_UserLogOnModel model = new MyTest.Model.Sys_UserLogOnModel(); if (row != null) { if (row["F_Id"] != null) { model.F_Id = row["F_Id"].ToString(); } if (row["F_UserId"] != null) { model.F_UserId = row["F_UserId"].ToString(); } if (row["F_UserPassword"] != null) { model.F_UserPassword = row["F_UserPassword"].ToString(); } if (row["F_UserSecretkey"] != null) { model.F_UserSecretkey = row["F_UserSecretkey"].ToString(); } if (row["F_AllowStartTime"] != null && row["F_AllowStartTime"].ToString() != "") { model.F_AllowStartTime = DateTime.Parse(row["F_AllowStartTime"].ToString()); } if (row["F_AllowEndTime"] != null && row["F_AllowEndTime"].ToString() != "") { model.F_AllowEndTime = DateTime.Parse(row["F_AllowEndTime"].ToString()); } if (row["F_LockStartDate"] != null && row["F_LockStartDate"].ToString() != "") { model.F_LockStartDate = DateTime.Parse(row["F_LockStartDate"].ToString()); } if (row["F_LockEndDate"] != null && row["F_LockEndDate"].ToString() != "") { model.F_LockEndDate = DateTime.Parse(row["F_LockEndDate"].ToString()); } if (row["F_FirstVisitTime"] != null && row["F_FirstVisitTime"].ToString() != "") { model.F_FirstVisitTime = DateTime.Parse(row["F_FirstVisitTime"].ToString()); } if (row["F_PreviousVisitTime"] != null && row["F_PreviousVisitTime"].ToString() != "") { model.F_PreviousVisitTime = DateTime.Parse(row["F_PreviousVisitTime"].ToString()); } if (row["F_LastVisitTime"] != null && row["F_LastVisitTime"].ToString() != "") { model.F_LastVisitTime = DateTime.Parse(row["F_LastVisitTime"].ToString()); } if (row["F_ChangePasswordDate"] != null && row["F_ChangePasswordDate"].ToString() != "") { model.F_ChangePasswordDate = DateTime.Parse(row["F_ChangePasswordDate"].ToString()); } if (row["F_MultiUserLogin"] != null && row["F_MultiUserLogin"].ToString() != "") { if ((row["F_MultiUserLogin"].ToString() == "1") || (row["F_MultiUserLogin"].ToString().ToLower() == "true")) { model.F_MultiUserLogin = true; } else { model.F_MultiUserLogin = false; } } if (row["F_LogOnCount"] != null && row["F_LogOnCount"].ToString() != "") { model.F_LogOnCount = int.Parse(row["F_LogOnCount"].ToString()); } if (row["F_UserOnLine"] != null && row["F_UserOnLine"].ToString() != "") { if ((row["F_UserOnLine"].ToString() == "1") || (row["F_UserOnLine"].ToString().ToLower() == "true")) { model.F_UserOnLine = true; } else { model.F_UserOnLine = false; } } if (row["F_Question"] != null) { model.F_Question = row["F_Question"].ToString(); } if (row["F_AnswerQuestion"] != null) { model.F_AnswerQuestion = row["F_AnswerQuestion"].ToString(); } if (row["F_CheckIPAddress"] != null && row["F_CheckIPAddress"].ToString() != "") { if ((row["F_CheckIPAddress"].ToString() == "1") || (row["F_CheckIPAddress"].ToString().ToLower() == "true")) { model.F_CheckIPAddress = true; } else { model.F_CheckIPAddress = false; } } if (row["F_Language"] != null) { model.F_Language = row["F_Language"].ToString(); } if (row["F_Theme"] != null) { model.F_Theme = row["F_Theme"].ToString(); } } return(model); }