/// <summary> /// 更新出入库订单返回金蝶状态 /// </summary> public static bool UpdateBatchPlanReturnState(string batchPlanId) { DataManager dm = new Invengo.RiceManangeServices.DBCommon.DataManager(); DBCommand cmd = dm.CreateDBCommand(CommandType.Text); cmd.ClearParameters(); cmd.setCommandText("update batchplan set upload=0 where batchplanid=@batchPlanId"); cmd.AddParameter("@batchPlanId", batchPlanId); return(dm.ExecNonQueryCommand(cmd)); }
/// <summary> /// 执行某条语句 /// </summary> /// <returns></returns> public static bool ExecNonQuerySql(string sql, List <SqlParameter> listSqlPara) { DataManager dm = new Invengo.RiceManangeServices.DBCommon.DataManager(); DBCommand cmd = dm.CreateDBCommand(CommandType.Text); cmd.setCommandText(sql); if (listSqlPara != null && listSqlPara.Count > 0) { for (int i = 0; i < listSqlPara.Count; i++) { cmd.AddParameter(listSqlPara[i]); } } return(dm.ExecNonQueryCommand(cmd)); }