/// <summary> /// 更新一条数据 /// </summary> public bool Update(AMS.Model.AMS_AuthorizeSys model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update AMS_AuthorizeSys set "); strSql.Append("SchoolId=@SchoolId,"); strSql.Append("AuthorizeStatus=@AuthorizeStatus,"); strSql.Append("InterfaceType=@InterfaceType,"); strSql.Append("EffectTime=@EffectTime,"); strSql.Append("EndTime=@EndTime,"); strSql.Append("AuthorizeCode=@AuthorizeCode,"); strSql.Append("IsComOrSch=@IsComOrSch,"); strSql.Append("Describe=@Describe"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@SchoolId", SqlDbType.Int, 4), new SqlParameter("@AuthorizeStatus", SqlDbType.Bit, 1), new SqlParameter("@InterfaceType", SqlDbType.NVarChar, 20), new SqlParameter("@EffectTime", SqlDbType.DateTime), new SqlParameter("@EndTime", SqlDbType.DateTime), new SqlParameter("@AuthorizeCode", SqlDbType.NVarChar, 50), new SqlParameter("@IsComOrSch", SqlDbType.Bit, 1), new SqlParameter("@Describe", SqlDbType.NVarChar, 200), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.SchoolId; parameters[1].Value = model.AuthorizeStatus; parameters[2].Value = model.InterfaceType; parameters[3].Value = model.EffectTime; parameters[4].Value = model.EndTime; parameters[5].Value = model.AuthorizeCode; parameters[6].Value = model.IsComOrSch; parameters[7].Value = model.Describe; parameters[8].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(AMS.Model.AMS_AuthorizeSys model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into AMS_AuthorizeSys("); strSql.Append("SchoolId,AuthorizeStatus,InterfaceType,EffectTime,EndTime,AuthorizeCode,IsComOrSch,Describe)"); strSql.Append(" values ("); strSql.Append("@SchoolId,@AuthorizeStatus,@InterfaceType,@EffectTime,@EndTime,@AuthorizeCode,@IsComOrSch,@Describe)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@SchoolId", SqlDbType.Int, 4), new SqlParameter("@AuthorizeStatus", SqlDbType.Bit, 1), new SqlParameter("@InterfaceType", SqlDbType.NVarChar, 20), new SqlParameter("@EffectTime", SqlDbType.DateTime), new SqlParameter("@EndTime", SqlDbType.DateTime), new SqlParameter("@AuthorizeCode", SqlDbType.NVarChar, 50), new SqlParameter("@IsComOrSch", SqlDbType.Bit, 1), new SqlParameter("@Describe", SqlDbType.NVarChar, 200) }; parameters[0].Value = model.SchoolId; parameters[1].Value = model.AuthorizeStatus; parameters[2].Value = model.InterfaceType; parameters[3].Value = model.EffectTime; parameters[4].Value = model.EndTime; parameters[5].Value = model.AuthorizeCode; parameters[6].Value = model.IsComOrSch; parameters[7].Value = model.Describe; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public AMS.Model.AMS_AuthorizeSys GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,SchoolId,AuthorizeStatus,InterfaceType,EffectTime,EndTime,AuthorizeCode,IsComOrSch,Describe from AMS_AuthorizeSys "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; AMS.Model.AMS_AuthorizeSys model = new AMS.Model.AMS_AuthorizeSys(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } if (ds.Tables[0].Rows[0]["SchoolId"] != null && ds.Tables[0].Rows[0]["SchoolId"].ToString() != "") { model.SchoolId = int.Parse(ds.Tables[0].Rows[0]["SchoolId"].ToString()); } if (ds.Tables[0].Rows[0]["AuthorizeStatus"] != null && ds.Tables[0].Rows[0]["AuthorizeStatus"].ToString() != "") { if ((ds.Tables[0].Rows[0]["AuthorizeStatus"].ToString() == "1") || (ds.Tables[0].Rows[0]["AuthorizeStatus"].ToString().ToLower() == "true")) { model.AuthorizeStatus = true; } else { model.AuthorizeStatus = false; } } if (ds.Tables[0].Rows[0]["InterfaceType"] != null && ds.Tables[0].Rows[0]["InterfaceType"].ToString() != "") { model.InterfaceType = ds.Tables[0].Rows[0]["InterfaceType"].ToString(); } if (ds.Tables[0].Rows[0]["EffectTime"] != null && ds.Tables[0].Rows[0]["EffectTime"].ToString() != "") { model.EffectTime = DateTime.Parse(ds.Tables[0].Rows[0]["EffectTime"].ToString()); } if (ds.Tables[0].Rows[0]["EndTime"] != null && ds.Tables[0].Rows[0]["EndTime"].ToString() != "") { model.EndTime = DateTime.Parse(ds.Tables[0].Rows[0]["EndTime"].ToString()); } if (ds.Tables[0].Rows[0]["AuthorizeCode"] != null && ds.Tables[0].Rows[0]["AuthorizeCode"].ToString() != "") { model.AuthorizeCode = ds.Tables[0].Rows[0]["AuthorizeCode"].ToString(); } if (ds.Tables[0].Rows[0]["IsComOrSch"] != null && ds.Tables[0].Rows[0]["IsComOrSch"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsComOrSch"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsComOrSch"].ToString().ToLower() == "true")) { model.IsComOrSch = true; } else { model.IsComOrSch = false; } } if (ds.Tables[0].Rows[0]["Describe"] != null && ds.Tables[0].Rows[0]["Describe"].ToString() != "") { model.Describe = ds.Tables[0].Rows[0]["Describe"].ToString(); } return(model); } else { return(null); } }