public int UpdMenu(menuModel model, SqlTransaction trans)
{
StringBuilder builder = new StringBuilder();
builder.Append("update frame_Desktop_Menulink");
builder.Append(" set orderId=@orderId,MNewName=@MNewName,sequence=@sequence ");
builder.Append(" where userCode=@userCode and ModelId=@ModelId");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@userCode", SqlDbType.VarChar, 50), new SqlParameter("@ModelId", SqlDbType.VarChar, 50), new SqlParameter("@orderId", SqlDbType.Int, 4), new SqlParameter("@MNewName", SqlDbType.VarChar, 100), new SqlParameter("@sequence", SqlDbType.VarChar, 2) };
commandParameters[0].Value = model.userCode;
commandParameters[1].Value = model.ModelId;
commandParameters[2].Value = model.orderId;
commandParameters[3].Value = model.MNewName;
commandParameters[4].Value = model.Sequence;
if (trans == null)
{
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters));
}
return(SqlHelper.ExecuteNonQuery(trans, CommandType.Text, builder.ToString(), commandParameters));
}
public int AddMenu(menuModel model, SqlTransaction trans)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into frame_Desktop_Menulink(");
builder.Append("userCode,ModelId,orderId,MNewName,addTime,sequence)");
builder.Append(" values (");
builder.Append("@userCode,@ModelId,@orderId,@MNewName,@addTime,@sequence)");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@userCode", SqlDbType.VarChar, 50), new SqlParameter("@ModelId", SqlDbType.VarChar, 50), new SqlParameter("@orderId", SqlDbType.Int, 4), new SqlParameter("@MNewName", SqlDbType.VarChar, 100), new SqlParameter("@addTime", SqlDbType.DateTime, 20), new SqlParameter("@sequence", SqlDbType.VarChar, 2) };
commandParameters[0].Value = model.userCode;
commandParameters[1].Value = model.ModelId;
commandParameters[2].Value = model.orderId;
commandParameters[3].Value = model.MNewName;
commandParameters[4].Value = model.AddTime;
commandParameters[5].Value = model.Sequence;
if (trans == null)
{
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters));
}
return(SqlHelper.ExecuteNonQuery(trans, CommandType.Text, builder.ToString(), commandParameters));
}
