/// <summary> /// /// </summary> /// <param name="takeOutObjectInfo"></param> /// <returns></returns> public int deleteTakeOutObject(TakeOutObjectInfo takeOutObjectInfo) { log.Debug("=================START deleteTakeOutObject================="); log.Debug("takeOutObjectInfo = " + takeOutObjectInfo.ToString()); StringBuilder sql_delete = new StringBuilder(); sql_delete.Append("DELETE FROM TakeOutObject WHERE takeOutObjectCode=" + takeOutObjectInfo.TakeOutObjectCode); int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql_delete.ToString(), null); log.Debug(@"=================END deleteTakeOutObject================="); return(result); }
/// <summary> /// /// </summary> /// <param name="takeOutObjectInfo"></param> /// <returns></returns> public int updateTakeOutObject(TakeOutObjectInfo takeOutObjectInfo) { log.Debug("=================START updateTakeOutObject================="); log.Debug("takeOutObjectInfo = " + takeOutObjectInfo.ToString()); StringBuilder sql_update = new StringBuilder(); sql_update.Append("UPDATE TakeOutObject SET codeName=N'" + takeOutObjectInfo.CodeName + "' , status=N'" + takeOutObjectInfo.Status + "' WHERE takeOutObjectCode=" + takeOutObjectInfo.TakeOutObjectCode); int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql_update.ToString(), null); log.Debug(@"=================END updateTakeOutObject================="); return(result); }
/// <summary> /// /// </summary> /// <param name="takeOutObjectInfo"></param> /// <returns></returns> public int insertTakeOutObject(TakeOutObjectInfo takeOutObjectInfo) { log.Debug("=================START insertTakeOutObject================="); log.Debug("takeOutObjectInfo = " + takeOutObjectInfo.ToString()); StringBuilder sql_insert = new StringBuilder(); sql_insert.Append("INSERT INTO TakeOutObject"); sql_insert.Append(" (codeName,regDate,status) "); sql_insert.Append(" VALUES "); sql_insert.Append(" (N'" + takeOutObjectInfo.CodeName + "', GETDATE(),N'" + takeOutObjectInfo.Status + "')"); int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql_insert.ToString(), null); log.Debug(@"=================END insertTakeOutObject================="); return(result); }