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