/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.SMT_STAFF_CARD model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update SMT_STAFF_CARD set "); strSql.Append("ACCESS_STARTTIME=@ACCESS_STARTTIME,"); strSql.Append("ACCESS_ENDTIME=@ACCESS_ENDTIME"); strSql.Append(" where STAFF_ID=@STAFF_ID and CARD_ID=@CARD_ID "); SqlParameter[] parameters = { new SqlParameter("@ACCESS_STARTTIME", SqlDbType.DateTime), new SqlParameter("@ACCESS_ENDTIME", SqlDbType.DateTime), new SqlParameter("@STAFF_ID", SqlDbType.Decimal,9), new SqlParameter("@CARD_ID", SqlDbType.Decimal, 9) }; parameters[0].Value = model.ACCESS_STARTTIME; parameters[1].Value = model.ACCESS_ENDTIME; parameters[2].Value = model.STAFF_ID; parameters[3].Value = model.CARD_ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Maticsoft.Model.SMT_STAFF_CARD model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SMT_STAFF_CARD("); strSql.Append("STAFF_ID,CARD_ID,ACCESS_STARTTIME,ACCESS_ENDTIME)"); strSql.Append(" values ("); strSql.Append("@STAFF_ID,@CARD_ID,@ACCESS_STARTTIME,@ACCESS_ENDTIME)"); SqlParameter[] parameters = { new SqlParameter("@STAFF_ID", SqlDbType.Decimal, 9), new SqlParameter("@CARD_ID", SqlDbType.Decimal, 9), new SqlParameter("@ACCESS_STARTTIME", SqlDbType.DateTime), new SqlParameter("@ACCESS_ENDTIME", SqlDbType.DateTime) }; parameters[0].Value = model.STAFF_ID; parameters[1].Value = model.CARD_ID; parameters[2].Value = model.ACCESS_STARTTIME; parameters[3].Value = model.ACCESS_ENDTIME; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.SMT_STAFF_CARD GetModel(decimal STAFF_ID, decimal CARD_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 STAFF_ID,CARD_ID,ACCESS_STARTTIME,ACCESS_ENDTIME from SMT_STAFF_CARD "); strSql.Append(" where STAFF_ID=@STAFF_ID and CARD_ID=@CARD_ID "); SqlParameter[] parameters = { new SqlParameter("@STAFF_ID", SqlDbType.Decimal, 9), new SqlParameter("@CARD_ID", SqlDbType.Decimal, 9) }; parameters[0].Value = STAFF_ID; parameters[1].Value = CARD_ID; Maticsoft.Model.SMT_STAFF_CARD model = new Maticsoft.Model.SMT_STAFF_CARD(); 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 Maticsoft.Model.SMT_STAFF_CARD DataRowToModel(DataRow row) { Maticsoft.Model.SMT_STAFF_CARD model = new Maticsoft.Model.SMT_STAFF_CARD(); if (row != null) { if (row["STAFF_ID"] != null && row["STAFF_ID"].ToString() != "") { model.STAFF_ID = decimal.Parse(row["STAFF_ID"].ToString()); } if (row["CARD_ID"] != null && row["CARD_ID"].ToString() != "") { model.CARD_ID = decimal.Parse(row["CARD_ID"].ToString()); } if (row["ACCESS_STARTTIME"] != null && row["ACCESS_STARTTIME"].ToString() != "") { model.ACCESS_STARTTIME = DateTime.Parse(row["ACCESS_STARTTIME"].ToString()); } if (row["ACCESS_ENDTIME"] != null && row["ACCESS_ENDTIME"].ToString() != "") { model.ACCESS_ENDTIME = DateTime.Parse(row["ACCESS_ENDTIME"].ToString()); } } return(model); }