public ActionResult WebTypeList() { long parentWebTypeID = XCLNetTools.StringHander.FormHelper.GetLong("parentWebTypeID"); parentWebTypeID = parentWebTypeID > 0 ? parentWebTypeID : base.V_CurrentUserModel.RootWebTypeID; Web.Models.WebType.WebTypeListModel model = new Models.WebType.WebTypeListModel(); model.ParentWebTypeID = parentWebTypeID; //select model.WebTypeOptionStr = Web.Common.CommonHelper.GetWebTypeOptionStr(base.CurrentUserModel.UserID, parentWebTypeID); //数据绑定 XCLShouCang.BLL.WebShareRelation relationBLL = new XCLShouCang.BLL.WebShareRelation(); XCLShouCang.Model.WebShareRelation relationModel = null; XCLShouCang.BLL.WebType webTypeBLL = new XCLShouCang.BLL.WebType(); XCLShouCang.BLL.v_WebType bll = new XCLShouCang.BLL.v_WebType(); model.WebTypeList = bll.GetModelList(parentWebTypeID, base.CurrentUserModel.UserID); model.WebShareRelationModel = new Models.WebShareRelation.WebShareRelationModel(); if (relationBLL.IsExistWebTypeRootID(base.V_CurrentUserModel.RootWebTypeID)) { relationModel = relationBLL.GetModelByWebTypeRootID(base.V_CurrentUserModel.RootWebTypeID); if (null != relationModel) { model.WebShareRelationModel.AccessPwd = relationModel.AccessPwd; model.WebShareRelationModel.IsShare = true; } } return(View("~/Views/UserAdmin/WebTypeList.cshtml", model)); }
public void SetShare() { Web.Models.WebShareRelation.WebShareRelationModel viewModel = new Models.WebShareRelation.WebShareRelationModel(); viewModel.IsShare = XCLNetTools.StringHander.FormHelper.GetInt("ckIsShare") == 1; viewModel.AccessPwd = XCLNetTools.StringHander.FormHelper.GetString("txtSharePwd"); viewModel.WebTypeRootID = base.V_CurrentUserModel.RootWebTypeID; XCLShouCang.BLL.WebShareRelation bll = new XCLShouCang.BLL.WebShareRelation(); XCLShouCang.Model.WebShareRelation model = new XCLShouCang.Model.WebShareRelation(); model.AccessPwd = viewModel.AccessPwd; model.FK_WebTypeRootID = viewModel.WebTypeRootID; model.FK_WebTypeRootID = base.V_CurrentUserModel.RootWebTypeID; XCLNetTools.Message.MessageModel msgModel = new XCLNetTools.Message.MessageModel(); if (bll.SetShare(model, viewModel.IsShare)) { msgModel.IsSuccess = true; msgModel.Message = "设置成功!"; } else { msgModel.IsSuccess = false; msgModel.Message = "操作失败,请重试!"; } XCLNetTools.Message.Log.WriteMessage(msgModel); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(XCLShouCang.Model.WebShareRelation model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update WebShareRelation set "); strSql.Append("FK_WebTypeRootID=@FK_WebTypeRootID,"); strSql.Append("AccessPwd=@AccessPwd"); strSql.Append(" where WebShareRelationID=@WebShareRelationID"); SqlParameter[] parameters = { new SqlParameter("@FK_WebTypeRootID", SqlDbType.BigInt, 8), new SqlParameter("@AccessPwd", SqlDbType.VarChar, 50), new SqlParameter("@WebShareRelationID", SqlDbType.BigInt, 8) }; parameters[0].Value = model.FK_WebTypeRootID; parameters[1].Value = model.AccessPwd; parameters[2].Value = model.WebShareRelationID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public long Add(XCLShouCang.Model.WebShareRelation model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into WebShareRelation("); strSql.Append("FK_WebTypeRootID,AccessPwd)"); strSql.Append(" values ("); strSql.Append("@FK_WebTypeRootID,@AccessPwd)"); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@FK_WebTypeRootID", SqlDbType.BigInt, 8), new SqlParameter("@AccessPwd", SqlDbType.VarChar, 50) }; parameters[0].Value = model.FK_WebTypeRootID; parameters[1].Value = model.AccessPwd; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt64(obj)); } }
/* * /// <summary> * /// 分页获取数据列表 * /// </summary> * public DataSet GetList(int PageSize,int PageIndex,string strWhere) * { * SqlParameter[] parameters = { * new SqlParameter("@tblName", SqlDbType.VarChar, 255), * new SqlParameter("@fldName", SqlDbType.VarChar, 255), * new SqlParameter("@PageSize", SqlDbType.Int), * new SqlParameter("@PageIndex", SqlDbType.Int), * new SqlParameter("@IsReCount", SqlDbType.Bit), * new SqlParameter("@OrderType", SqlDbType.Bit), * new SqlParameter("@strWhere", SqlDbType.VarChar,1000), * }; * parameters[0].Value = "WebShareRelation"; * parameters[1].Value = "WebShareRelationID"; * parameters[2].Value = PageSize; * parameters[3].Value = PageIndex; * parameters[4].Value = 0; * parameters[5].Value = 0; * parameters[6].Value = strWhere; * return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds"); * }*/ #endregion BasicMethod #region ExtensionMethod /// <summary> /// 设置共享状态 /// </summary> public bool SetShare(XCLShouCang.Model.WebShareRelation model, bool isShare) { SqlParameter[] parameters = { new SqlParameter("@ResultCode", SqlDbType.Int, 4), new SqlParameter("@ResultMessage", SqlDbType.NVarChar, 1000), new SqlParameter("@IsShare", SqlDbType.TinyInt, 1), new SqlParameter("@FK_WebTypeRootID", SqlDbType.BigInt, 8), new SqlParameter("@AccessPwd", SqlDbType.VarChar, 50) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Direction = ParameterDirection.Output; parameters[2].Value = isShare?1:0; parameters[3].Value = model.FK_WebTypeRootID; parameters[4].Value = model.AccessPwd; DbHelperSQL.RunProcedure("proc_WebShareRelationUpdate", parameters, "ds"); int flag = XCLNetTools.StringHander.Common.GetInt(parameters[0].Value); if (flag > 0) { return(true); } else { throw new Exception(Convert.ToString(parameters[1].Value)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public XCLShouCang.Model.WebShareRelation DataRowToModel(DataRow row) { XCLShouCang.Model.WebShareRelation model = new XCLShouCang.Model.WebShareRelation(); if (row != null) { if (row["WebShareRelationID"] != null && row["WebShareRelationID"].ToString() != "") { model.WebShareRelationID = long.Parse(row["WebShareRelationID"].ToString()); } if (row["FK_WebTypeRootID"] != null && row["FK_WebTypeRootID"].ToString() != "") { model.FK_WebTypeRootID = long.Parse(row["FK_WebTypeRootID"].ToString()); } if (row["AccessPwd"] != null) { model.AccessPwd = row["AccessPwd"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public XCLShouCang.Model.WebShareRelation GetModel(long WebShareRelationID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 WebShareRelationID,FK_WebTypeRootID,AccessPwd from WebShareRelation "); strSql.Append(" where WebShareRelationID=@WebShareRelationID"); SqlParameter[] parameters = { new SqlParameter("@WebShareRelationID", SqlDbType.BigInt) }; parameters[0].Value = WebShareRelationID; XCLShouCang.Model.WebShareRelation model = new XCLShouCang.Model.WebShareRelation(); 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 Update(XCLShouCang.Model.WebShareRelation model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public long Add(XCLShouCang.Model.WebShareRelation model) { return(dal.Add(model)); }
/// <summary> /// 分页获取数据列表 /// </summary> //public DataSet GetList(int PageSize,int PageIndex,string strWhere) //{ //return dal.GetList(PageSize,PageIndex,strWhere); //} #endregion BasicMethod #region ExtensionMethod /// <summary> /// 设置共享 /// </summary> public bool SetShare(XCLShouCang.Model.WebShareRelation model, bool isShare) { return(dal.SetShare(model, isShare)); }