public int Add(Rain.Model.navigation model)
{
using (OleDbConnection oleDbConnection = new OleDbConnection(DbHelperOleDb.connectionString))
{
oleDbConnection.Open();
using (OleDbTransaction trans = oleDbConnection.BeginTransaction())
{
try
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("insert into " + this.databaseprefix + "navigation(");
stringBuilder.Append("parent_id,channel_id,nav_type,[name],title,sub_title,icon_url,link_url,sort_id,is_lock,[remark],action_type,is_sys)");
stringBuilder.Append(" values (");
stringBuilder.Append("@parent_id,@channel_id,@nav_type,@name,@title,@sub_title,@icon_url,@link_url,@sort_id,@is_lock,@remark,@action_type,@is_sys)");
OleDbParameter[] oleDbParameterArray = new OleDbParameter[13]
{
new OleDbParameter("@parent_id", OleDbType.Integer, 4),
new OleDbParameter("@channel_id", OleDbType.Integer, 4),
new OleDbParameter("@nav_type", OleDbType.VarChar, 50),
new OleDbParameter("@name", OleDbType.VarChar, 50),
new OleDbParameter("@title", OleDbType.VarChar, 100),
new OleDbParameter("@sub_title", OleDbType.VarChar, 100),
new OleDbParameter("@icon_url", OleDbType.VarChar, (int)byte.MaxValue),
new OleDbParameter("@link_url", OleDbType.VarChar, (int)byte.MaxValue),
new OleDbParameter("@sort_id", OleDbType.Integer, 4),
new OleDbParameter("@is_lock", OleDbType.Integer, 4),
new OleDbParameter("@remark", OleDbType.VarChar, 500),
new OleDbParameter("@action_type", OleDbType.VarChar, 500),
new OleDbParameter("@is_sys", OleDbType.Integer, 4)
};
oleDbParameterArray[0].Value = (object)model.parent_id;
oleDbParameterArray[1].Value = (object)model.channel_id;
oleDbParameterArray[2].Value = (object)model.nav_type;
oleDbParameterArray[3].Value = (object)model.name;
oleDbParameterArray[4].Value = (object)model.title;
oleDbParameterArray[5].Value = (object)model.sub_title;
oleDbParameterArray[6].Value = (object)model.icon_url;
oleDbParameterArray[7].Value = (object)model.link_url;
oleDbParameterArray[8].Value = (object)model.sort_id;
oleDbParameterArray[9].Value = (object)model.is_lock;
oleDbParameterArray[10].Value = (object)model.remark;
oleDbParameterArray[11].Value = (object)model.action_type;
oleDbParameterArray[12].Value = (object)model.is_sys;
DbHelperOleDb.ExecuteSql(oleDbConnection, trans, stringBuilder.ToString(), oleDbParameterArray);
model.id = this.GetMaxId(oleDbConnection, trans);
trans.Commit();
}
catch
{
trans.Rollback();
return(-1);
}
}
}
return(model.id);
}
public bool Update(Rain.Model.navigation model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("update " + this.databaseprefix + "navigation set ");
stringBuilder.Append("parent_id=@parent_id,");
stringBuilder.Append("channel_id=@channel_id,");
stringBuilder.Append("nav_type=@nav_type,");
stringBuilder.Append("[name]=@name,");
stringBuilder.Append("title=@title,");
stringBuilder.Append("sub_title=@sub_title,");
stringBuilder.Append("icon_url=@icon_url,");
stringBuilder.Append("link_url=@link_url,");
stringBuilder.Append("sort_id=@sort_id,");
stringBuilder.Append("is_lock=@is_lock,");
stringBuilder.Append("[remark]=@remark,");
stringBuilder.Append("action_type=@action_type,");
stringBuilder.Append("is_sys=@is_sys");
stringBuilder.Append(" where id=@id");
OleDbParameter[] oleDbParameterArray = new OleDbParameter[14]
{
new OleDbParameter("@parent_id", OleDbType.Integer, 4),
new OleDbParameter("@channel_id", OleDbType.Integer, 4),
new OleDbParameter("@nav_type", OleDbType.VarChar, 50),
new OleDbParameter("@name", OleDbType.VarChar, 50),
new OleDbParameter("@title", OleDbType.VarChar, 100),
new OleDbParameter("@sub_title", OleDbType.VarChar, 100),
new OleDbParameter("@icon_url", OleDbType.VarChar, (int)byte.MaxValue),
new OleDbParameter("@link_url", OleDbType.VarChar, (int)byte.MaxValue),
new OleDbParameter("@sort_id", OleDbType.Integer, 4),
new OleDbParameter("@is_lock", OleDbType.Integer, 4),
new OleDbParameter("@remark", OleDbType.VarChar, 500),
new OleDbParameter("@action_type", OleDbType.VarChar, 500),
new OleDbParameter("@is_sys", OleDbType.Integer, 4),
new OleDbParameter("@id", OleDbType.Integer, 4)
};
oleDbParameterArray[0].Value = (object)model.parent_id;
oleDbParameterArray[1].Value = (object)model.channel_id;
oleDbParameterArray[2].Value = (object)model.nav_type;
oleDbParameterArray[3].Value = (object)model.name;
oleDbParameterArray[4].Value = (object)model.title;
oleDbParameterArray[5].Value = (object)model.sub_title;
oleDbParameterArray[6].Value = (object)model.icon_url;
oleDbParameterArray[7].Value = (object)model.link_url;
oleDbParameterArray[8].Value = (object)model.sort_id;
oleDbParameterArray[9].Value = (object)model.is_lock;
oleDbParameterArray[10].Value = (object)model.remark;
oleDbParameterArray[11].Value = (object)model.action_type;
oleDbParameterArray[12].Value = (object)model.is_sys;
oleDbParameterArray[13].Value = (object)model.id;
return(DbHelperOleDb.ExecuteSql(stringBuilder.ToString(), oleDbParameterArray) > 0);
}
private bool DoEdit(int _id)
{
try
{
Rain.BLL.navigation navigation = new Rain.BLL.navigation();
Rain.Model.navigation model = navigation.GetModel(_id);
model.name = this.txtName.Text.Trim();
model.title = this.txtTitle.Text.Trim();
model.sub_title = this.txtSubTitle.Text.Trim();
model.icon_url = this.txtIconUrl.Text.Trim();
model.link_url = this.txtLinkUrl.Text.Trim();
model.sort_id = int.Parse(this.txtSortId.Text.Trim());
model.is_lock = 0;
if (this.cbIsLock.Checked)
{
model.is_lock = 1;
}
model.remark = this.txtRemark.Text.Trim();
if (model.is_sys == 0)
{
int num = int.Parse(this.ddlParentId.SelectedValue);
if (num != model.id)
{
model.parent_id = num;
}
}
string str = string.Empty;
for (int index = 0; index < this.cblActionType.Items.Count; ++index)
{
if (this.cblActionType.Items[index].Selected && Utils.ActionType().ContainsKey(this.cblActionType.Items[index].Value))
{
str = str + this.cblActionType.Items[index].Value + ",";
}
}
model.action_type = Utils.DelLastComma(str);
if (navigation.Update(model))
{
this.AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "修改导航菜单:" + model.title);
return(true);
}
}
catch
{
return(false);
}
return(false);
}
public Rain.Model.navigation GetModel(string nav_name)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("select top 1 id,parent_id,channel_id,nav_type,[name],title,sub_title,icon_url,link_url,sort_id,is_lock,[remark],action_type,is_sys");
stringBuilder.Append(" from " + this.databaseprefix + "navigation ");
stringBuilder.Append(" where name=@nav_name");
OleDbParameter[] oleDbParameterArray = new OleDbParameter[1]
{
new OleDbParameter("@nav_name", OleDbType.VarChar, 50)
};
oleDbParameterArray[0].Value = (object)nav_name;
Rain.Model.navigation navigation = new Rain.Model.navigation();
DataSet dataSet = DbHelperOleDb.Query(stringBuilder.ToString(), oleDbParameterArray);
if (dataSet.Tables[0].Rows.Count > 0)
{
return(this.DataRowToModel(dataSet.Tables[0].Rows[0]));
}
return((Rain.Model.navigation)null);
}
private Rain.Model.navigation DataRowToModel(DataRow row)
{
Rain.Model.navigation navigation = new Rain.Model.navigation();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
navigation.id = int.Parse(row["id"].ToString());
}
if (row["parent_id"] != null && row["parent_id"].ToString() != "")
{
navigation.parent_id = int.Parse(row["parent_id"].ToString());
}
if (row["channel_id"] != null && row["channel_id"].ToString() != "")
{
navigation.channel_id = int.Parse(row["channel_id"].ToString());
}
if (row["nav_type"] != null)
{
navigation.nav_type = row["nav_type"].ToString();
}
if (row["name"] != null)
{
navigation.name = row["name"].ToString();
}
if (row["title"] != null)
{
navigation.title = row["title"].ToString();
}
if (row["sub_title"] != null)
{
navigation.sub_title = row["sub_title"].ToString();
}
if (row["icon_url"] != null)
{
navigation.icon_url = row["icon_url"].ToString();
}
if (row["link_url"] != null)
{
navigation.link_url = row["link_url"].ToString();
}
if (row["sort_id"] != null && row["sort_id"].ToString() != "")
{
navigation.sort_id = int.Parse(row["sort_id"].ToString());
}
if (row["is_lock"] != null && row["is_lock"].ToString() != "")
{
navigation.is_lock = int.Parse(row["is_lock"].ToString());
}
if (row["remark"] != null)
{
navigation.remark = row["remark"].ToString();
}
if (row["action_type"] != null)
{
navigation.action_type = row["action_type"].ToString();
}
if (row["is_sys"] != null && row["is_sys"].ToString() != "")
{
navigation.is_sys = int.Parse(row["is_sys"].ToString());
}
}
return(navigation);
}
public bool Update(Rain.Model.navigation model)
{
return(this.dal.Update(model));
}
public int Add(Rain.Model.navigation model)
{
return(this.dal.Add(model));
}
