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));
}
